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.

Vlookup with the result being once cell below the orginal value
 

Use this instead

=INDEX(E10:E4009,MATCH(M2,A10:A4009,0)+1)



--


Regards,


Peo Sjoblom


"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.

Vlookup with the result being once cell below the orginal value
 

Use MATCH to find the row and then incorporate into an INDEX formula. Look
in the help index for MATCH & INDEX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

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.