I have created a dependent dropdown list, column 1 in the master, and independen

Question

I have created a dependent dropdown list, column 1 in the master, and independent. column 2 is dependent on the result in column 1. But I also need a third column, that is dependent on the result of the 1st column too.all I seem to get is errors.

I have succeeded in doing it by putting the results I require in the same table as the results that go in column 2 are in, but when I click to select the result for column 3 I also see column 2 results.

eg, columns are (1) diameter, (2) length, (3) tower.

(1) diameter 168 mm   an independent selection that initialises the results in the next column

(2) length      54 m        this is dependent on the figure I select in column 1 (diameter)

93) tower      Standard this is dependent on the figure I select in column 1 (diameter)

the values for the third column are standard, high, superhigh, high tow.

is anyone able to point me in the right direction on this please?

Thank you

Explanation / Answer

Hi,

Try this

1. Select A6:A8 of the Towers Worksheet and assign it a name, A_254

2. Click on cell D3 of Design sheet and go to Data > Validation > Allow > List and enter this formula

=INDIRECT("A_"&B3)

3. Click on OK.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.