Pull down list in a cell

[gord9b]

I know there is a way of setting up a cell to display a list of valid inputs. I cannot find out how to do this. When the user clicks on the cell, or passes the mouse over the cell, a pop up list is displayed and one of these inputs is selected and is displayed in the cell. How do I do this?
Based on the selected input in this cell, can I use a VLOOKUP to insert another value in another, adjacent cell?

 

[Aladin Akyurek]

It looks like you want a dropdown list you set up by using data validation.

 

[Chris Davison]

Hi Gordon,

in answer to your second question, yes.... you are bang on.

in answer to your first : you'll need data validation.

if you can afford your list of selections (drop down items) on the same sheet, just list them out vertically (say Z1:Z10)

then in your list of cells where you want your dropdown to appear you go :

data
validation
settings
allow = list
scource = Z1:Z10
in cell dropdown = checked / ticked

or, instead of entering Z1:Z10 as the list range, you can put in a named range (say =mylist).

The named range should already be defined though : to do this :

insert
name
define
name = mylist
range = $Z$1:$Z$10

Naming the actual range (in my view) is better as it just reads easier that some anchored formula, and it also allows you to put the named range *on a different sheet* if you have no space to spare on the same sheet...... always handy

(none of this is going to work if you just want a dropdown by hovvering over the cell with your mouse.... you're going to need some nice VBA coding for that)

 

[gord9b]

Thanks. This sounds like exactly what I am looking for. I will try it immediately.