Help with IFS

Occasional Visitor


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


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.