Forum Discussion
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",""...
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.