Excel 2007 : How to populate Drop Down LIst with Range Names

I have a work book with 10 range names, each representing blocks of cells. I am using a VLOOKUP formula and trying to use a drop down list of the 10 range names to populate the table array portion of the VLOOKUP formula. I keep getting an error. It appears that the data in the drop down list is just text and not the actual range of cells. Any sugestions would be appreciated. The VLOOKUP nworks fine when I type the range name directly into the formula.

Thanks

KSams,

Welcome to the forum!
It sounds to me like what you're looking for is the Indirect() function. Assuming you have the drop down list containing the range names in cell A1:
=VLOOKUP("lookup value",INDIRECT(A1),2,FALSE)