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)#
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)#
Thank you for your advice and updating my workbook. I'll review all at work tomorrow and advise if any further queries or if your kind response has resolved everything.
Thanks again