HLookUP errors on only Certain Cells

[JH_AA]

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

[#2]

@JH_AA 

Perhaps you may give more details? In general formula works

[#3]

@Sergei Baklan 

[#4]

[#5 · Accepted solution]

@JH_AA 

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

Please see HLOOKUP function (microsoft.com)

[#6]

@Sergei Baklan 

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

[#7]

@JH_AA , glad to help