SOLVED

HLookUP errors on only Certain Cells

New Contributor

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

6 Replies

@JH_AA 

Perhaps you may give more details? In general formula works

image.png

 

JH_AA_0-1649958709023.png

 

best response confirmed by Hans Vogelaar (MVP)
Solution

@JH_AA 

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

image.png

Please see HLOOKUP function (microsoft.com)

@Sergei Baklan 

 

thanks, that was the trick.  Looked around a lot to try and figure that one out.

@JH_AA , glad to help