Forum Discussion
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.??
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.
thanks I will give it a try