Vlookup
 

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

Vlookup
 

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


"ynissel" wrote:

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

Vlookup
 

wow - thata bit complicated for me. if you have the time - can you explain
what these fuctions (offset, address, match) do?
Thanks.

"Elkar" wrote:

See if this works for you:

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

HTH,
Elkar


"ynissel" wrote:

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

Vlookup
 

If Excel help isn't working on your machine, try reinstalling Excel.
Help describes all those functions, and gives examples.
--
David Biddulph

"ynissel" wrote in message
...
wow - thata bit complicated for me. if you have the time - can you
explain
what these fuctions (offset, address, match) do?
Thanks.

"Elkar" wrote:

See if this works for you:

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

HTH,
Elkar


"ynissel" wrote:

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

Vlookup
 

See if this works for you:

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

HTH,
Elkar


"ynissel" wrote:

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