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)#