Trying to create a list with two columns and two tables.
For table 1....In column 1 you have status and column 2 you have text.
In column 1 (status) each row has a dropdown menu (data validation list) that contains two options....yes and no. In column 2 you have text besides column 1 (e.g ROW 1 -> status - yes, text - hello, ROW 2 -> status - no, text - goodbye).
For table 2...Trying to make a dropdown menu for each cell using data validation list which only shows/lists the corresponding values in the cell dropdown that say yes (from table 1). For values that are no, I want it to say not available. This dynamic dropdown list should change whenever the status column for a specific row in table 1 is changed.
Any ideas on how to do this? Would I use the FILTER function in data validation, lists?
