V Lookup

L

Lin4it

Why when using a V Lookup do I get the result from the row above that required?

=VLOOKUP("Greater London",range1,2,0)

The answer should be 29 but I am getting the contents of the cell above.
 
D

Dave Peterson

=vlookup() will find the first match. And there's a match above the cell that
you think is the first match.

Any chance you have some hidden rows in range1 that you haven't noticed?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LOOKUP returning wrong values 2
Changing Source Data using V-lookup 3
v-Lookup between values and give result -Help 3
Lookup question and iferror compatibility 6
Using v-lookup with multiple identifiers 2
Vlookup and Data Validation Q 2
V lookup and H lookup together 4
VLOOKUP return cell location and hyperlink 0

Top