Please help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

timmyc - 28 Feb 2006 12:45 GMT

Is it possible to create a vlookup that looks firsly down the second
column in a table to find the cell value but then brings back the value
from the 1st column?

Thanks, Tim

Signature

timmyc

Reply to this Message

Bob Phillips - 28 Feb 2006 12:57 GMT

=INDEX($A$1:$A$100,MATCH(value,$B$1:$B$100,0))

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Is it possible to create a vlookup that looks firsly down the second
> column in a table to find the cell value but then brings back the value
> from the 1st column?
>
> Thanks, Tim

Reply to this Message

broro183 - 28 Feb 2006 13:07 GMT

Hi,

Bob, you beat me to this one :-)

Tim,
If you want some explanation of Bob's formula, check out:
http://www.ozgrid.com/Excel/left-lookup.htm
or
http://www.cpearson.com/excel/lookups.htm
or even Google "left lookup", excel

hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience..

Reply to this Message

broro183 - 28 Feb 2006 13:08 GMT

Signature

broro183

Reply to this Message

Antonio Elinon - 28 Feb 2006 13:44 GMT

If you want a strictly vlookup solution, propagate a formula copy of column A
into column C, (eg, in cell C1 put "=A1", and copy all the way down.) Then
you can use a normal vlookup syntax on column B, and your offset will 2.
This has been useful for me when there is an existing vlookup and you cannot
move columns around.

Regards,
Antonio Elinon

> Is it possible to create a vlookup that looks firsly down the second
> column in a table to find the cell value but then brings back the value
> from the 1st column?
>
> Thanks, Tim

Reply to this Message