Hello Folks. Need help with this one. I want to call out the data based on the name of the company from the drop down list. For example if I select Company 1 from the drop down, all data from company 1 will be extracted and will appear in the filled portions in the result. I'm thinking of doing it Index Match but I can't do it with multiple logic since Company 1 has Coal, Wind and Geo. attached is the excel file. thank you to those who'll respond.
powerplant.PNG
Bookmarks