1

Why does my VLOOKUP return 5 instead of 1

enter image description here

And to show it's selecting the correct cells

enter image description here

=VLOOKUP(G1, $A$9:$B$11,2,1) 

Why is it returning 5 instead of 1

1 Answer 1

2

In the last parameter of your VLOOKUP, you are using 1, which is equivalent to TRUE, which tells VLOOKUP to use an approximate match. Change it to 0 or FALSE.

You must log in to answer this question.

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