Feb 09 2022 06:32 PM
hello,
i am using office 365, and appreciate for indulging in this discussion.
in the above picture i am forming a data table for raw materials. basically i want excel automatically response to the selective dropdown to vendor one.
eg.
in data table
say from dropdown in C6 I choose material as steel, then in D6 vendor i should get steel dropdown list accordingly.
Feb 09 2022 07:48 PM
Hi, I'm new here, not sure how to attach a file, but here's what you can do:
Note: you can change "Table1" with any name for your table
Hope it helps
Feb 09 2022 09:06 PM
Another alternative could be using the filter formula.
=FILTER(Table6[[BOARD]:[STEEL]],C6=Table6[[#Headers],[BOARD]:[STEEL]])
and then in the data validation list select the cell where you are using this formula.
For example if that formula was in P12, in the data validation list use P12#