Vlookup and drop down lists

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top