How do I. VLOOKUP & BRING BACK THE CELL BELOW THE CELL WHICH IS FO

[Guest]

Hi
Can anyone help.

I want to do a VLOOKUP and bring back the cell below the cell which is found.
eg normal vlookup - VLOOKUP(a1,SHEET,5,0). But I want to bring back the cell
below the 5th cell accross.
I have tried using the combination of OFFSET & VLOOKUP but I can't get a
result.

Cheers

 

[Dave Peterson]

=index(sheet2!e:e,match(a1,sheet2!a:a,0)+1))

is one way.

 

[Guest]

Try something like this:

With
C1:G10 containing the lookup table

A1: (a value from the first column of the lookup table)

This formula returns the value from the 5th column, corresponding to the
lookup value, and one cell down.
B1: =INDEX(C1:G10,MATCH(A1,C1:C10,0)+1,5)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP