Forum Discussion

uchidozie's avatar
uchidozie
Copper Contributor
Dec 15, 2025

Conditional data validation drop downs

I have a table with everyone's availability. Column A is names, Column B is Monday morning, Column C is Monday afternoon and so on. In another cell, I want a drop down list of names if they're available at that time. If( [Monday Morning] = "Available") put it in the drop down list and then do that for the whole week. When I try to do formulas in the data validation page it doesn't work.

excel
Excel for web

1 Reply

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Dec 15, 2025

    Hi

    Assuming your data is on Sheet1 with Names in A2:A5:

    Create a new Sheet2 (you can hide later):

    #1 On Sheet2 in A2 then copy right as necessary:

    =FILTER( Sheet1!$A2:$A5, Sheet1!B2:B5 = "available", "" )

    #2 Switch to Sheet1 > In Data Validation on B7 and copy right as necessary:

    =Sheet2!A$2#

    (Don't forget the # sign at the end)

    Sample avail. at: https://1drv.ms/x/c/1cd824d35610aacb/IQBN8UpV0kxfQJ5AFzs1WF3hARCxMpkCqNADQBR6vtlVPMY?e=uaMDfX

Resources