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


Perhaps you may give more details? In general formula works





best response confirmed by Hans Vogelaar (MVP)


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


Please see HLOOKUP function (

@Sergei Baklan 


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

@JH_AA , glad to help