Why not just add a DV with a list option referencing the data list.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"dsharb52" wrote in message
...
When I set up a vlookup in a cell, I would like a drop-down list to appear
instead of the single value in the specified column.

Is this possible.