The video demonstrates a method to consolidate a value by created dependent dropdown list with the Indirect and Vlookup functions.
Dependent dropdown list in excel is very useful feature for business analysis and decision support, like an approach of multi criteria decision tree, it is widely used with predefined criteria for example: in sales strategy analysis, sales operational performance evaluation, product performance evaluation, sales incentive plan with territory allocations etc.
ide. Hope the video bring some idea to create useful excel tool for your business analysis needs
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/