Offset Vlookup

[Randombard]

Hi All,

I would like to perform a vlookup but return the value in the cell 1 row below the found cell

I have tried addind offset in front of vlookup but that does not appear to work

Little help pleas

 

[Andrew Poulsom]

To do that use INDEX/MATCH adding 1 to the MATCH result, eg:

=INDEX(B1:B100,MATCH(C1,A1:A100,FALSE)+1)

 

[Randombard]

Thanks Andrew your a star.

I was being slow as usual on a monday

I ended up with this

=INDEX(INDIRECT(A$83),MATCH(A83,INDIRECT(A$83),0)+1,0)

All the best