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