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. Your solution has worked a dream. Being honest, I'm not quite sure how the various functions in the formulas you provided work but they do!......it gives me something to work on in developing my knowledge.
Thanks again
Jon_R1968 , you are welcome.
I'm not sure where this pattern is explained in details, but if you have concrete questions please ask.