Drop-down menu

[excelfreedom]

Is it possible to create a drop-down menu that is link to each other?
-> Column 1 has items Object A,B,C. When I select Object A, in Column 2 only items under Object A will be shown (A1,A2,A3). When I select Object B, only items under Object B will be shown (B1,B2,B3), and so on. Same goes to Column 3, when I select A1, only items under A1 will be shown (a1,a2,a3) and so on.

waNvY1T.jpg

[meus]

Here you go... Is it the way you wanted??
Add some reps and mark thread as solved if it helped you..

[excelfreedom]

Here you go... Is it the way you wanted??
Add some reps and mark thread as solved if it helped you..

Great. thanks.
Can you provide a steps on how did you do this?
I want to add this to my knowledge bank.

[meus]

Hey!
Glad that it helped
For Column 2, firstly select cell B2 and go to Data tab- Data Validation and select LIST from the drop down menu... and use the "IF" Statement in the Source..

Please Login or Register  to view this content.

[excelfreedom]

Thanks meus

[meus]

Welcome.. Don't forget to mark thread as solved...
And Please add me some reputation by clicking the star below..
Cheers

[excelfreedom]

Many thanks.
How to mark it as solved?

Follow up to my problem:
-> When I select A1 from the drop-down menu, it will automatically put the values to Column 1 (100) and Column 2 (1000).
-> When I select A2 from the drop-down menu, it will automatically put the values to Column 1 (200) and Column 2 (2000).
-> When I select A3 from the drop-down menu, it will automatically put the values to Column 1 (300) and Column 2 (3000).
-> and so on.

2.jpg

[BadlySpelledBuoy]

In cell B7 of your example pic above, enter the formula:

Please Login or Register  to view this content.

and copy right to C7.

BSB