V Lookup
 

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.

V Lookup
 

=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?

Lin4it wrote:

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.

--

Dave Peterson