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" <jparker.1tks2a_1123722309.1185@excelforum-nospam.com> wrote in
message news:jparker.1tks2a_1123722309.1185@excelforum-nospam.com...
>
> 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
>