Adjusting lookup range

[Guest]

Hello - I am using a lookup function e.g lookup(a1, b1:c55) - but I would
like to be able to ajust the range of the lookup vector based on values in
other cells.

E.g. I would like to be able to type 3 and 21 into cells M1 and N1 and make
my formula adjust to Lookup(a1, b3:c21).

Does anyone have any ideas?

Thanks so much!

 

[Pete_UK]

Try this:

=LOOKUP(A1,INDIRECT("B"&M1&":C"&N1))

Hope this helps.

Pete

 

[Bob Phillips]

=LOOKUP(A1, OFFSET(B3,,,N1-M1+1,2))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)