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

Cumulative formula for word table 0
Changing Source Data using V-lookup 2
LOOKUP returning wrong values 2
Function or Sub to help with text string 5
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Lookup question and iferror compatibility 6
v-Lookup between values and give result -Help 3
lookup values from certain text file. 0

Top