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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 16 Nov 2006 02:18 GMT

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

Reply to this Message

Dave Peterson - 16 Nov 2006 02:32 GMT

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

is one way.

> Hi
> Can anyone help.
[quoted text clipped - 6 lines]
>
> Cheers

Signature

Dave Peterson

Reply to this Message

Ron Coderre - 16 Nov 2006 02:42 GMT

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

> Hi
> Can anyone help.
[quoted text clipped - 6 lines]
>
> Cheers

Reply to this Message