Do you need a list of possible selections in cell depending on some condition?



I myself use in such cases a pair of columns with data validation lists defined for them, where data validation list in 2nd column depends on selected value in 1st column.

For this I have a hidden sheet with a table where all possible selections for 1st column from data table are column headers, and in every column all possible selections for 2nd column from data table are listed. And then a dynamic named range is defined, which represents the range with possible selections from one column from hidden sheet, depending the selection in 1st column on data table (i.e. the named range is dynamic as it changes when you select another row in data table, and it is dynamic, as it selects different length ranges data from different columns on hidden sheet. The data validation list for 2nd column is set equal to defined dynamic range.

The table on hidden sheet can be filled manually, or it can be also dynamic, with columns calculated from other data in workbook.