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