Forum Discussion
Solved
HLookUP errors on only Certain Cells
I have a HLOOKUP formula comparing numbers 1-12 to a table with 1-12 (months). the formula works for numbers 4-12, but not 1-3, getting a #NA error. I compared the cells containing 1-3 with the table, and they are the same. But, still getting
On unsorted range you need to use FALSE as 4th parameter for exact match
Please see HLOOKUP function (microsoft.com)
