IF resulting in Drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-3362091%22%20slang%3D%22en-US%22%3EIF%20resulting%20in%20Drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362091%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20have%20an%20IF%20value%20produce%20a%20Drop%20Drop%20Down%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20clarity%20I%20have%20an%20existing%20formula%20as%20follows%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIFNA(IF(AND(A15%26gt%3B%3DLodgement!%24C%2413%2CA15%26lt%3B%3DLodgement!%24E%2413)%2C%22Waiting%20Period%22%2C%22%22)%2C%22%22)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20update%20the%20existing%20formula%20so%20that%20if%20the%20cell%20does%20NOT%20say%20%22Waiting%20Period%22%20it%20instead%20displays%20a%20drop%20down%20list%20which%20is%20located%20in%20another%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3362091%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362147%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20resulting%20in%20Drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1387807%22%20target%3D%22_blank%22%3E%40Jay-B%3C%2FA%3E%26nbsp%3BNot%20sure%20if%20I%20understood%20it%20correctly%2C%20but%20if%20you%20want%20to%20display%20a%20drop%20down%2C%20only%20when%20a%20certain%20condition%20is%20met%2C%20perhaps%20the%20example%20in%20the%20picture%20below%20will%20help.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-05-12%20at%2006.10.09.png%22%20style%3D%22width%3A%20337px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371022iD431AF0EF5A45CA4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-05-12%20at%2006.10.09.png%22%20alt%3D%22Screenshot%202022-05-12%20at%2006.10.09.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIt%20will%20only%20display%20the%20options%20if%20A2%20contains%20%22x%22.%20Otherwise%20the%20drop%20down%20will%20not%20show%20any%20options.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

 

1 Reply

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

Screenshot 2022-05-12 at 06.10.09.png

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