Hello all! I am looking for some assistance with a combo box. I have created a simple combo box based on a list of 16 cities. My combo box works where I can hit the drop down and toggle between my 16 cities.
With that said, I am looking to make my worksheet "interactive" meaning when I toggle between cities I am looking to have Vlookups reference the city in my combo box and pull back values that I have "hidden" on a separate worksheet. Is this possible? Am I making any sense or can I clarify better?
Currently, I have a normal dropdown list housed in cell D5 and I have a bunch of vlookups on my working sheet referencing information on my hidden sheet. This works and works fine, however I want a combo box because the dropdown arrow is always displayed whereas with my dropdown it isn't until you hover over it.
Thank you all for your assistance and input in helping me resolve this issue - if at all possible
With that said, I am looking to make my worksheet "interactive" meaning when I toggle between cities I am looking to have Vlookups reference the city in my combo box and pull back values that I have "hidden" on a separate worksheet. Is this possible? Am I making any sense or can I clarify better?
Currently, I have a normal dropdown list housed in cell D5 and I have a bunch of vlookups on my working sheet referencing information on my hidden sheet. This works and works fine, however I want a combo box because the dropdown arrow is always displayed whereas with my dropdown it isn't until you hover over it.
Thank you all for your assistance and input in helping me resolve this issue - if at all possible
