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.
Bookmarks