Excel Tips & Tricks: Dropdown List by Indirect Function with Range
This video demonstrates a way on using excel Indirect function to generate a dropdown list with a range. This is one way you may have the dropdown list switched and changed among many created name ranges dynamically according to the cell reference which is placed in the data validation source formula.
For more info of my BI & Analytics, please refer to the following website links:
My BI & Analytics Website:
https://sites.google.com/view/mikegua...
My blog website :
https://mikeyubianalytics.blogspot.com/
![Complete online adult ballet center [30 minutes]](https://images.videosashka.com/watch/IgZEpRMQ-cE)
