Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have this:

d   a   1   =VLOOKUP(A1,$B$1:$C$5,1)
e   b   2   =VLOOKUP(A2,$B$1:$C$5,1)
f   c   3   =VLOOKUP(A3,$B$1:$C$5,1)
g   d   4   =VLOOKUP(A4,$B$1:$C$5,1)
h   e   5   =VLOOKUP(A5,$B$1:$C$5,1)

But its gives me this:

d   a   1   4
e   b   2   5
f   c   3   5
g   d   4   5
h   e   5   5

When I expect this:

d   a   1   4
e   b   2   5
f   c   3   N/A
g   d   4   N/A
h   e   5   N/A

What am I doing wrong?

share|improve this question
up vote 1 down vote accepted

You need to add the range lookup parameter (FALSE) to your formula to find an exact match.

=VLOOKUP(A1,$B$1:$C$5,1,FALSE)
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .