Are multiple Vlookup's possible?

[Simon Lloyd]

Hi all,

i am using this =VLOOKUP(F1,TiedEquip,4,FALSE) on my worksheet and it is located in D1, what i would like to do is a VLookup like this.....=VLookup(F1,C1 ,4,FALSE), where C1 on the same sheet would be the name of the named range to look at, this way i can have a drop down list of names which would change the contents of D1 based on the value in F1 because as i change the name in C1 it would look to a different named range!

Don't know whether i was clear explaining that.....but is it possible?

Regards,
Simon

[Chip Pearson]

Use the INDIRECT function

=VLookup(F1,INDIRECT(C1) ,4,FALSE)

This will cause VLOOKUP to scan the table whose name or address
is in C1.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Simon Lloyd"
<[email protected]> wrote
in message
news:[email protected]...
>
> Hi all,
>
> i am using this =VLOOKUP(F1,TiedEquip,4,FALSE) on my worksheet
> and it
> is located in D1, what i would like to do is a VLookup like
> this.....=VLookup(F1,C1 ,4,FALSE), where C1 on the same sheet
> would be
> the name of the named range to look at, this way i can have a
> drop down
> list of names which would change the contents of D1 based on
> the value
> in F1 because as i change the name in C1 it would look to a
> different
> named range!
>
> Don't know whether i was clear explaining that.....but is it
> possible?
>
> Regards,
> Simon
>
>
> --
> Simon Lloyd
> ------------------------------------------------------------------------
> Simon Lloyd's Profile:
> http://www.excelforum.com/member.php...fo&userid=6708
> View this thread:
> http://www.excelforum.com/showthread...hreadid=546307
>

[Bob Phillips]

=VLookup(F1,INDIRECT(C1) ,4,FALSE)

should be what you need

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Simon Lloyd" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi all,
>
> i am using this =VLOOKUP(F1,TiedEquip,4,FALSE) on my worksheet and it
> is located in D1, what i would like to do is a VLookup like
> this.....=VLookup(F1,C1 ,4,FALSE), where C1 on the same sheet would be
> the name of the named range to look at, this way i can have a drop down
> list of names which would change the contents of D1 based on the value
> in F1 because as i change the name in C1 it would look to a different
> named range!
>
> Don't know whether i was clear explaining that.....but is it possible?
>
> Regards,
> Simon
>
>
> --
> Simon Lloyd
> ------------------------------------------------------------------------
> Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
> View this thread: http://www.excelforum.com/showthread...hreadid=546307
>

[Simon Lloyd]

Thanks to Chip and Bob.............worked well!

Regards,
Simon