Forum Discussion
Dependent Drop Downs across multiple rows in a spreadsheet
Hello. I've been trying to create a spreadsheet that has a dependent dropdown column. However, all the guides and advice I've seen so far have been functional only when you only need a single cell or...
So this is the closest solution I can find that actually works, using XLOOKUP: https://www.youtube.com/watch?v=fjn4vlWwpCo
However, when editing the Data validation version of XLOOKUP, it won't let me remove the dollar sign to allow it to be dragged down and function properly. Really annoying since this is so close.
However, when editing the Data validation version of XLOOKUP, it won't let me remove the dollar sign to allow it to be dragged down and function properly. Really annoying since this is so close.