Apr 14 2022 09:36 AM
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
Apr 14 2022 10:30 AM
Apr 14 2022 12:24 PM
SolutionOn unsorted range you need to use FALSE as 4th parameter for exact match
Please see HLOOKUP function (microsoft.com)
Apr 15 2022 05:07 AM
Apr 14 2022 12:24 PM
SolutionOn unsorted range you need to use FALSE as 4th parameter for exact match
Please see HLOOKUP function (microsoft.com)