drop list dependant on other drop list selection

  • Thread starter Thread starter intjdragonuser
  • Start date Start date
I

intjdragonuser

How do I make a drop list that is used with the cell-validation feature
depend on the selection from the drop list/cell validation of a
previously filled cell?

Example: Cell A2 can be Hot, Warm, or Cold. If Hot is selected, cell
A3 can be red, yellow or orange. If Warm is selected, cell A3 can be
black, gray or white. If Cold is selected, cell A3 can be blue, green
or purple.

Individual lists may be up to 25 items long.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
The Contextures produce sample with the INDIRECT function requires the
dependant cells to run in parallel columns.

My cell B2 will be filled from a "Town" list, then cells from A6 on down
column A should have droplists (Streets) dependant on the answer in B2.
Rows 1 - 4 have static data except for B2. Col C will fill
automatically depending on the item selected for cells in col A.

Someone sent a sample sheet with "Supervisor" and Staff (I'm at another
office) Everything works, but I can't break the code on the syntax!

The second cell (my A6) has the validation Fx Source:
=INDIRECT(VLOOKUP(Supervisor,SupervisorLookup,2,False)).
"Supervisor" is a Defined Name =Sheet1!$A$1. "SupervisorLookup"
=Sheet1!$D$2:$E$5. I do not know why the ranges were named, what "2"
signifies, and why the "FALSE".

I have 2 days to finish this thing...

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
Back
Top