Vlookup with the result being once cell below the orginal value

[Alex]

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.

 

[Peo Sjoblom]

Use this instead

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



--


Regards,


Peo Sjoblom

 

[Don Guillett]

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

 

[T. Valko]

Try this:

=INDEX(Sheet1!$E$10:$E$4009,MATCH($M2,Sheet1!$A$10:$A$4009,0)+1)