Multiple Selection from Drop Down lists and Return all Results in lookup

[karunk]

Good Morning and thank you for the help.

I was following up on some additional excel help.

I have an excel dashboard that I built and I have a dropdown list located in cell C1 on the tab labeled Account_Dashboard. I'd like a few things to change here:

I'd like the dropdown like to show the dropdown arrow all the time, now just when you click in the cell, I'd also like the user to be able to change this to a combo box so that the user can select multiple accounts if the account Hierarchy group ID in column bv in the survey data lookup tab is the same. The issue I have is that the account name can be stored in several different ways. The unique identifier is the Hierarchy group but I can't expect the user to be able to know what this ID number is when making the selection in the dashboard.

The answers to the survey need to be looked up and returned in the solutions below. I could easily change the lookup value to be the hierarchy number but i can't imagine having to do this every month. If anyone has a solution, i would really appreciate the help.

Thanks,

Survey Dashboard May 20220518 v2.xlsm

drive.google.com