Mar 15 2021 04:26 PM - edited Mar 15 2021 05:07 PM
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!
Mar 15 2021 06:55 PM
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.