Yes, cells P1..P10 have their own unique data validation drop list. The
source of each list is defined in the NAME BOX. For example: cell P1
will have a data validation table named as ITEM1, P2 has a table named
as ITEM2, and so forth. The ITEM1 table is located in cells Z1..Z3.
The entries are Z1=Red, Z2=White, Z3=Blue. The ITEM2 table is in cells
Z4..Z6. The entries are Z4 = green, Z5 = yellow, Z6 = black. P3..P10
are similar.

When I type ITEM1 in cell A1, I would like to be able to use vlookup to
display the drop down list in A2 (once I move the cursor there). A2
should display the list and give me the choice of selecting either red,
white, or blue. Thanks.


--
jparker
------------------------------------------------------------------------
jparker's Profile: http://www.excelforum.com/member.php...o&userid=26155
View this thread: http://www.excelforum.com/showthread...hreadid=394806