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"
wrote
in message
...

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