V Lookup

  • Thread starter Thread starter Lin4it
  • Start date Start date
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.
 
=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?
 
Back
Top