CODEWITHSUNDEEP
excelvlookup
atp03
atp03

Reputation: 3699

Super simple VLOOKUP cannot retrieve the values as expected

This seemingly simple vlookup is not working and not picking up the specified value of 1 in ColA:

=VLOOKUP(C1,A:B,0,FALSE)

VLOOKUP

Any ideas what is wrong?

Upvotes: 0

Views: 42

Answers (1)

Harun24hr
Harun24hr

Reputation: 36780

Try Index(), Match() combination like below.

=INDEX(A:A,MATCH(C1,B:B,0))

enter image description here

Upvotes: 2

Related Questions