Insert drop-down into a cell?

J

jweasl

I need to have my cell be a drop-down menu itself, and have the options
reference a list in another sheet in the same workbook. I have a workbook in
which it is done, but I can't figure out how they did it. I can't put a combo
box over the cell, because then my vlookup formulas won't work when the value
is selected.
 
B

bpeltzer

On the sheet where you want the drop-down, define a name as the item list in
the other sheet (Insert > Name > Define). Then use that defined name as the
list in the dropdown.
 
D

Duke Carey

Under the Data menu is the Validation option. In there, select List and
point to the list on the other page.
 
R

Raydel

I need to be able to retrieve text from a list as I type the firs
letters of the word.. any clues?
Thanks
 
Top