I have used an index match formula numerous times, and have never had a problem. For some reason it just won't work today. I have the following values in my sheet:
Cal 08 60.00
Cal 09 57.00
Cal 10 61.00
Cal 11 56.00
Cal 12 44.00
Look up value 60.00
Result Cal 08
When 60 is entered, Cal 08 is displayed as it should be.
When 57 is entered, a #N/A error is displayed.
When a number that is not in the list such as 99 is entered, Cal 12 is displayed
I have attached this spreadsheet. Hopefully someone can explain to me why this isn't working.
Index Match Formula Error.xlsx
Thank you for any help you can provide!
-B-
Bookmarks