data validation multiple list

October 28, 2010 at 04:54:38
Specs: Windows XP
make the 2nd list of a multiple drop down list change along with the 1st list. I use the data validation tab, and for the 2nd list I use the function. "=indirect(1st cell)" instead of the 2nd list changing when I change the 1st list. the 2nd list stays with whatever list I choose for the 1st list. Should I be using a different function to allow the 2nd list to change along with the 1st list.

See More: data validation multiple list

Report •

October 28, 2010 at 05:55:17
In order for the 2nd (dependent) list to change, the data for the 2nd list needs to be in a Named Range which is named the same as the values in the first list.

If your first list contains:


Then all of your Food items should be in a Range named Food. That will make the INDIRECT function refer to the Named Range.

Report •

October 28, 2010 at 07:29:09
I actually can get the 1st row to work using INDIRECT function "1st and 2nd list". But when I try to drag the 1st row list down(or the initial list cell) then the 2nd column always refers to whatever the 1st list cell item is. I have to change the 1st list cell item for the 2nd list cell item to change in the following rows. To make all the rows work, not just the 1st row, Am i still using the indirect function?

Report •

October 28, 2010 at 12:48:53
Are you using =INDIRECT($A$1) or =INDIRECT(A1)

If you're using =INDIRECT($A$1) then it's going to stay "locked" to A1 when you drag it down.

Use =INDIRECT(A1) and it will increment to A2.

Report •
Related Solutions

Ask Question