I have a very complicated exercise but I am changing it around so it is easier
What I have been using is the formula
=VLOOKUP(1,A1:O10, 2, FALSE)

This is looking up 1 in column a
What I want to do is be able to look up say 1 in column b
How would I do this
Also this is for a list of values would I be able to put a cell reference
say b2 instead of the 1 so I can copy the formula all the way down
thanks

--
Natalie