Prev: Smaller than 0 to return a 0 result
Next: Ignore Zero's - Percentile
From: Lin4it on 18 Feb 2010 09:29
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.
From: Dave Peterson on 18 Feb 2010 09:55
=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
 | 
Pages: 1
Prev: Smaller than 0 to return a 0 result
Next: Ignore Zero's - Percentile