CODEWITHSUNDEEP
arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
Sandy
Sandy

Reputation: 359

Why vlookup in excel either returned NA or mismatched?

I have two tables as below. I tried several times and could not understand why Vlookup cannot work. 

EE ID     Application
000101     
000121   
000137   
000158   
000175   
000182   
000209

Table 2 for match

EE ID   Application
000182   o
000223   o
000292   o
000305   o
000311   o
000314   o
000353   o
000356   o

I just wanna match the o in table two to table one. I used like this

=VLOOKUP(A2,Off!A:B,2)   and get all #N/A
=VLOOKUP(A2,off!A:B,2,)  and get lots of mismatch.

Can anyone help?

Upvotes: 1

Views: 109

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(IFNA(VLOOKUP(A2:A, OFF!A:B, 2, 0)))

0

spreadsheet demo

Upvotes: 1

Related Questions