Drop down selections for multiple parameters

[Thomas Kuriakose]

Dear All,

We have a sheet where we need to select values from a drop down list and on selection of the first drop down, the second drop down should show values based on the first selected parameter and similarly the third drop down should be giving selections based on the second selected parameter.

Kindly help in getting a solution for this. A sample file is attached.

thanks,

with regards.
thomas

 

[Thomas Kuriakose]

Please find the file attached

thank you so much.

 

[eibi]

Thomas,

Paste this formula in your data validation criteria for cell C12

=OFFSET($B$2,MATCH($C$11,$B$3:$B$7,0),1,1,4)

The next step isn't quite as clean --

Do you only have materials for the Spare Parts SubGroup? What if I pick subgroup Tripohor, for example? How do you want to populate the Materials dropdown menu?

If you will only use the Materials group for Spare Parts, you can paste the following formula in the data validation criteria for cell C13

=OFFSET($F$2,1,MATCH($C$12,$C$3:$F$3,0),4,1)

But if you want to grow this list at all, or have subsets for other Sub Groups, you'll need to think about building those lists a little differently.

See attached. Does this do what you want?

 

[bobhc]

You will find all you need at the link


http://www.contextures.com/xlDataVal02.html


.

 

[Thomas Kuriakose]

Thomas,

Paste this formula in your data validation criteria for cell C12

=OFFSET($B$2,MATCH($C$11,$B$3:$B$7,0),1,1,4)

The next step isn't quite as clean --

Do you only have materials for the Spare Parts SubGroup? What if I pick subgroup Tripohor, for example? How do you want to populate the Materials dropdown menu?

If you will only use the Materials group for Spare Parts, you can paste the following formula in the data validation criteria for cell C13

=OFFSET($F$2,1,MATCH($C$12,$C$3:$F$3,0),4,1)

But if you want to grow this list at all, or have subsets for other Sub Groups, you'll need to think about building those lists a little differently.

See attached. Does this do what you want?

 

[Thomas Kuriakose]

Dear Sir,

There is an exhaustive list for Group/Sub Group and Materials. The sample i created has a few inputs only.

What is the best way to get a drop down in cells for such cases.

Thank you so much,

with regards,
thomas

 

[eibi]

Take a look at the link mentioned by Ninja bobhc above:

You will find all you need at the link
http://www.contextures.com/xlDataVal02.html

If you need help applying this, it would be great to have a sample file from you with more of your lists so we can see what layout and volume you're dealing with.

Also, do you plan to add to the lists? If so, this is something to plan in from the beginning. Adding one item in the future can require reworking a whole spreadsheet if you don't build in that flexibility from the start.