I apologize if this has already been addressed somewhere else, but I
could not find it....

I have a timesheet that I'm creating that relies heavily on data
validation driving drop-down lists. I've created ranges for all the
possible results of the drop-down choices, however, when I want to
query additional information in a named range through VLOOKUP, I cannot
use the result of the drop-down choice as the valid range. Despite the
cell displaying the range name it cannot pass this to VLOOKUP without
giving me an error.

Does anyone know how I can take the displayed result in a drop down box
and use this to fuel the table array for a VLOOKUP...in a worksheet
function !?!

Willy D.


--
willydlish
------------------------------------------------------------------------
willydlish's Profile: http://www.excelforum.com/member.php...o&userid=19985
View this thread: http://www.excelforum.com/showthread...hreadid=345730