Forum Discussion
Solved
Dynamic Drop Down Lists
Hi, I'm trying to set up a multi row schedule whereby once a selection is made from a Drop down list in Column B it automatically identifies the relative options in a Drop Down list in Column C (all...
You may prepare data for it as
with
=TRANSPOSE(FILTER(Table1[Item],Table1[Location]=$Q2))and use for data validation in column C
=XLOOKUP($B2,Data!$Q$2#,Data!$R$2:$R$6)#
Excel always (well, almost always) gives us multiple ways to accomplish the same fundamental task.
Here's an example of yet another way to have a secondary data validation (or drop-down) which changes based on the selection of the first.
Thank you for taking the time to respond to my query. I had previously started working on the solution SergeiBaklan provided (which worked) and thus haven't used your solution but do appreciate your input.
Thanks again
