Forum Discussion

Copper Contributor

Apr 14, 2022

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

excel

Formulas and Functions

SergeiBaklan
Apr 14, 2022
JH_AA

On unsorted range you need to use FALSE as 4th parameter for exact match

Please see HLOOKUP function (microsoft.com)

JH_AA

Copper Contributor

Apr 14, 2022

SergeiBaklan

Diamond Contributor

Apr 14, 2022

JH_AA

On unsorted range you need to use FALSE as 4th parameter for exact match

Please see HLOOKUP function (microsoft.com)

JH_AA
Copper Contributor
Apr 15, 2022
SergeiBaklan

thanks, that was the trick. Looked around a lot to try and figure that one out.
- SergeiBaklan
  Diamond Contributor
  Apr 15, 2022
  JH_AA , glad to help