Forum Discussion
VLookup returning #NA - syntax correct
I am struggling to understand why I'm getting an #NA error. The formula is correct from what I can tell. Formula is: =VLOOKUP(Expenses!A2,Sheet1!$A$2:$B$49214,2,FALSE) 3 page excel workbook, tab 1 n...
K2good The result #NA means that column A on Sheet1 does not contain an exact match for the value of A2 on Expenses. For example, if Expenses!A2 contains "John " and there is a cell in Sheet1!A2:B49214 that contains "John" but no cell that contains "John ", there is no exact match.
Actually the value did exist in the table. It was a formatting and sort issue.