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!

Try this:

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

Hope this helps.

Pete

On Oct 1, 5:00 pm, Snara <Sn...@discussions.microsoft.com> wrote:
> 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!

=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)

"Snara" <(E-Mail Removed)> wrote in message
news:F5FCA6A2-8966-4628-B314-(E-Mail Removed)...
> 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!
>
>