Vlookup

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[David Biddulph]

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

 

[Guest]

See if this works for you:

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

HTH,
Elkar