we get data from another source and cut & paste into our spreadsheet - so in other words static data, we then want to have a conditional dropdown box. i've found several things with the choice of one dropdown allows options for the next dropdown but not a static data point - help
i thought maybe an if statement, it didn't work:
list for data validation: =if(table1[[#thisrow],[lg]]=30,lg30titles,... and so on)
we can't do a dropdown for lg as it is from the cut & paste data (so in other words static data) but that is what we want to be the "selector" for which data validation list we want to show in titles
i thought maybe an if statement, it didn't work:
list for data validation: =if(table1[[#thisrow],[lg]]=30,lg30titles,... and so on)
we can't do a dropdown for lg as it is from the cut & paste data (so in other words static data) but that is what we want to be the "selector" for which data validation list we want to show in titles
