Microsoft Excel Tips and Tricks
In this Microsoft Excel video tutorial I explain how to populate a list based on a cell’s value or two cells’ values. This can be achieved using the FILTER function.
Credit Chester Tugwell
Excel: Populate List Based on Cell Value | Populate Rows Based on Cell Value