Lookup Problem

[stephen.smith]

Hi Guys I have a small problem with a lookup formula.
I am trying to perform a lookup formula that will look in cells B5:G5 for the number 2 which in turn will return the value I have placed beside the number 2 in my lookup table which is in Cells I2:J5. Can you please help.
Thanks In Advance.
Stephen

 

[Tom Urtis]

What is the correlation between where in range B5:G5 the number 2 is found and what bearing it has in (supposedly) a lookup table in I2:J5? If you know the number you are looking for, why not apply that to the table to return what you want, unless the column (B, C, D, E, F, or G) of where 2 (or whatever you are looking for) matters, which if so you should explain in more detail.

 

[CWatts]

It works for me...

=LOOKUP(2,$B$2:$B$5,$C$2:$C$5)

However, the lookup function requires the lookup vector to be in ascending order. If that is not the case, you will get an error. If putting the values in ascending order is not an option, you'd be better off using the vlookup formula

=VLOOKUP(2,$B$2:$C$5,2,FALSE)