Help with IFS

%3CLINGO-SUB%20id%3D%22lingo-sub-2212313%22%20slang%3D%22en-US%22%3EHelp%20with%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2212313%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20on%20a%20pc%20using%20Windows%2010%20(version%2020H2)%20and%20Microsoft%20365%20Apps.%26nbsp%3B%20Attached%20is%20my%20spreadsheet%20where%20I%20am%20trying%20to%20get%20Catagory%202%20and%203%20populate%20dependant%20on%20Catagory%201%20and%202.%26nbsp%3B%20For%20example%2C%20if%20Communications%20System%20is%20choosen%20in%20Cat%201%20then%20Cat%202%20would%20give%203%20options%20and%20if%20iPhones%20was%20then%20choosen%20in%20Cat%202%20then%204%20options%20would%20populate%20in%20Cat%203.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2212313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2212529%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2212529%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F998285%22%20target%3D%22_blank%22%3E%40aeuresti%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20question%20has%20nothing%20to%20do%20with%20IFS()%20but%20with%20dependent%20drop%20down%20lists.%3C%2FP%3E%3CP%3EAttached%20is%20a%20solution%20with%20dynamic%20arrays.%20But%20then%20you%20need%20a%20lot%20of%20additional%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello.

I am on a pc using Windows 10 (version 20H2) and Microsoft 365 Apps.  Attached is my spreadsheet where I am trying to get Catagory 2 and 3 populate dependant on Catagory 1 and 2.  For example, if Communications System is choosen in Cat 1 then Cat 2 would give 3 options and if iPhones was then choosen in Cat 2 then 4 options would populate in Cat 3.

 

Please and thank you!

1 Reply

@aeuresti 

Your question has nothing to do with IFS() but with dependent drop down lists.

Attached is a solution with dynamic arrays. But then you need a lot of additional columns.