Vlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ynissel - 28 Mar 2007 00:17 GMT

Is there anyway (without rearranging columes to have my lookup column the
second one i the list.
i.e. I need to look up a number in colume 2 and get the value in column 1
something like vlookup(2,a1:b3,-1)

a b
2.5 1
3.6 2
5.235 3

Reply to this Message

Teethless mama - 28 Mar 2007 01:21 GMT

=INDEX(A1:A3,MATCH(2,B1:B3,0))

> Is there anyway (without rearranging columes to have my lookup column the
> second one i the list.
[quoted text clipped - 5 lines]
> 3.6 2
> 5.235 3

Reply to this Message

Elkar - 28 Mar 2007 02:59 GMT

See if this works for you:

=OFFSET(INDIRECT(ADDRESS(MATCH(2,$A$1:$B$3,0),COLUMN($B$1))),0,-1)

HTH,
Elkar

> Is there anyway (without rearranging columes to have my lookup column the
> second one i the list.
[quoted text clipped - 5 lines]
> 3.6 2
> 5.235 3

Reply to this Message