Forum Discussion

Jay-B's avatar
Jay-B
Copper Contributor
May 12, 2022

IF resulting in Drop down list

Is it possible to have an IF value produce a Drop Drop Down list?

 

For clarity I have an existing formula as follows

 

=IFNA(IF(AND(A15>=Lodgement!$C$13,A15<=Lodgement!$E$13),"Waiting Period",""),"")

 

I want to update the existing formula so that if the cell does NOT say "Waiting Period" it instead displays a drop down list which is located in another worksheet.

 

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 12, 2022

    Jay-B Not sure if I understood it correctly, but if you want to display a drop down, only when a certain condition is met, perhaps the example in the picture below will help.

    It will only display the options if A2 contains "x". Otherwise the drop down will not show any options.

Resources