Vlookup

Y

ynissel

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
 
Y

ynissel

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

David Biddulph

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

Elkar

See if this works for you:

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

HTH,
Elkar
 
Top