Your question sure isn't clear to me, but maybe Debra Dalgiesh's excellent
help for drop down lists will aid you

http://www.contextures.com/xlDataVal01.html



"luke013" wrote:

have a spreadsheet with a validation list, and used vlookup to drag in other
information that goes with that cell. i need a column that refers to one of
the vlookup cells, bu gives a list of input options that match the
information in the referance cell. is this possible??
--