Wednesday, November 18, 2020

Google Sheets - Create a Dynamic Dropdown List

Want to learn how to create a dynamic drop down list in Google Sheets? It happens when you click a small drop down arrow in the cell and it shows you a list of choices. Then after the first selection from that drop down list will help filter another drop down list for another set of options to choose from. This is pretty easy to do by involving the named ranges, the data validation feature and the INDIRECT function.

No comments:

Post a Comment