G
Guest
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
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