Free Support Forum -

Possible bug in MATCH function - cannot do horizontal lookups


There appears to be a bug in the MATCH function. I have a spreadsheet where MATCH works correctly for searching a vertical range, but returns no value (eg IsErrorValue = True) for a horizontal range.

This works:

MATCH(100, A1:A3, 0) returns index of 100 in range A1:A3

This does NOT work:

MATCH(100, A1:C1, 0) returns “#N/A” regardless of lookup value.

Is this a bug or a problem in my spreadsheet? We will need to be able to use MATCH horizontally.

Many thanks.

If values in A1:C1 are all blank, the returned value will be “#N/A”. I tested with other values and it works fine. Could you please give me more information about the problem? Could you attach your file here?