hey, drop down lists are a bit confusing, but I found this article a bit helpful in terms of doing it in my spreadsheet. You can check this out for more information.

https://www.efinancialmodels.com/kno...tion-in-excel/