Hi!

The lookup table is cells P1 to P10. That part is simple. The cells in the
lookup table are blank except for their own validation table

When you say: "validation table" are you talking about a Data Validation
drop down list?

If that's the case, what is the source for the drop downs you now have in
P1:P10?

Those individual sources are what you need to make this work.

So, what you want is a user selected drop down source, right?

Actually, this is very easy but somewhat difficult to explain. If I'm on the
right track post back and let me know.

Biff

"jparker" wrote in
message ...

First, I know about the Copy-Paste Special command. However, I want to
use a vlookup table that will lookup an item that is typed in cell A1
and display the result in cell A2. The lookup table is cells P1 to
P10. That part is simple. The cells in the lookup table are blank
except for their own validation table. I would like cell A2 to display
the validation table for the value of cell A1.


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