CODEWITHSUNDEEP
excelvlookup
Zaiem Othman
Zaiem Othman

Reputation: 83

Vlookup doesnt read mixture of Alphabet and Numbers eg: 1T902462K01

i have a table as below and i wanted to compare result using Vlookup.

    A     | B     | C
-------------------------
1 | ID    | Name  | Lot
-------------------------
2 | 70100 | Krenn | VF849062
-------------------------
3 | 70101 | Georg | VE803354
-------------------------
4 | 70102 | Mohd  | VE803354

However =VLOOKUP(C2,A1:C4,1,FALSE) will result #N/A

Any advise?

Regards, Zaiem

Upvotes: 0

Views: 51

Answers (1)

teylyn
teylyn

Reputation: 35970

Try the Index/Match suggested in the comments. It goes like this:

=index(A1:A4,match(F1,C1:C4,0))

in words: find the value of F1 in the range C1 to C4 and return the value from column A for the same row.

Your Vlookup formula references C2, which does not make sense if column C is the column where you perform the lookup.

Upvotes: 1

Related Questions