Forum Discussion

JH_AA's avatar
JH_AA
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...

Resources