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.
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.
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?