Forum Discussion

wkm21's avatar
wkm21
Copper Contributor
Nov 28, 2019

NA in Vlookup

Hello

 

I am having an issue with vlookup. I am using a simple formula but still getting NA for all of my entries. I have attached my test data can you please tell me what is wrong.??

excel
Formulas and Functions

2 Replies

  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Silver Contributor
    Nov 28, 2019

    wkm21 

    That's because, in VLookup function, the lookup value should be in the first column of the table_array which is not the case in your formula.

     

    For this scenario you may either use Index/Match or XLookup if you have access to the dynamic array formulas.

     

    You may try it like this...

     

    Index/Match:

    In B2

    =IFERROR(INDEX(dat!B:B,MATCH(A2,dat!C:C,0)),"")

    and then copy it down.

     

    XLookup:

    In B2

    =XLOOKUP(A2,dat!C:C,dat!B:B,"",0)

    and then copy it down.

     

     

     

Resources