IF resulting in Drop down list

[Jay-B]

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.

[#2]

@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.