Vlookup and drop down lists
 

Question: I have 2 columns:

A
B
"Blower rotation is correct"
"Electricy is on"
"filters are installed"



Currently, B is empty. Each Item in column A has a number of possiblilities
for the user to enter into column B. I would like to put these into a drop
down menu in each cell in column B. Is there a way to insert a particular
drop box unique to a cell in column A. I have roughly 30 items in Column A
thus 30 different drop down menu's. The hard part is that Column A is a
sorted list that changes based on inputs from the user. Can the IF function
handle this many drop down menu possibilities in one cell? Please help

Vlookup and drop down lists
 

It sounds like you are looking for a conditional dropdown... check out this
link...

http://www.xldynamic.com/source/xld.Dropdowns.html
--
HTH...

Jim Thomlinson


"Bwells" wrote:

Question: I have 2 columns:

A
B
"Blower rotation is correct"
"Electricy is on"
"filters are installed"



Currently, B is empty. Each Item in column A has a number of possiblilities
for the user to enter into column B. I would like to put these into a drop
down menu in each cell in column B. Is there a way to insert a particular
drop box unique to a cell in column A. I have roughly 30 items in Column A
thus 30 different drop down menu's. The hard part is that Column A is a
sorted list that changes based on inputs from the user. Can the IF function
handle this many drop down menu possibilities in one cell? Please help