View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Vlookup with the result being once cell below the orginal value

Hi

I have a vlookup in which I wanted to return the value for the cell right
below what would have the orginal cell.

This is the Formula I have. The result will return the value in E100 since
the value looking is in A100. I want the resulting value to be in E101
instead.

=VLOOKUP($M2,Sheet1!$A$10:$H$4009,5,FALSE)

Any assistance is appreciated.