Jul 07 2021 02:51 PM - edited Jul 07 2021 03:36 PM
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 not referenced, tab 2 is source lookup (Expenses), tab 3 is table array (Sheet1).
What am I missing?
Resolved: The table array was not sorted in ascending order AND the results column was not formatted the same as the other source column.
Jul 07 2021 03:05 PM
What am I missing
Simple answer: There is no value in Sheet1!A2:A49214 which is equal to Expenses!A2.
Jul 07 2021 03:06 PM
@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.
Jul 07 2021 03:35 PM
Jul 07 2021 03:35 PM