Forum Discussion

K2good's avatar
K2good
Copper Contributor
Jul 07, 2021

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...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jul 07, 2021

K2good 

 

What am I missing

Simple answer: There is no value in Sheet1!A2:A49214 which is equal to Expenses!A2.

 

 

  • K2good's avatar
    K2good
    Copper Contributor
    Jul 07, 2021
    Actually, I checked and the value does exist in the table. The actual problem was the array was not sorted in ascending order AND column B was not formatted the same as the others. Took a minute to get it figured out (with help from an expert).