Hope everyone is well,

I'd like to create an interactive map that when my product is selected from a drop down menu, the store locations the specific product are located in will highlight.

Im firstly having an issue with being able to populate the specific infomation. The total inventory is on one sheet and includes brands, qty of sizes and locations. Desired end result is to select "nike" from the drop down menu, and a custom map (an image which I have already created), the map will highlight the stores where nikes are located.

does this make sense?