Thread: V Lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lin4it Lin4it is offline
external usenet poster
 
Posts: 4
Default 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.