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
|