Vlookup with the result being once cell below the orginal value
Try this:
=INDEX(Sheet1!$E$10:$E$4009,MATCH($M2,Sheet1!$A$10 :$A$4009,0)+1)
--
Biff
Microsoft Excel MVP
"Alex" wrote in message
...
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.
|