Need advice on creating a 'Roll Down' menu

Dear Forum members,

I want to create three Roll Down menu's at the top of my Excel sheet next to each other (hope 'Roll Down' menu is the correct name). In these Roll Down menu's you can choose from multiple products. But, here is the tricky part. I want it to able to show all the data of these products. This way I can easily compare three products with all the data next to each other.

So my question to you is if you know how to make a Roll Down menu that will show all the data of the specific product, that a person choose, in the designated cells?

Thank you in advance for your time and effort!

Cordially,

BremmesN

Hi & welcome to the Forum,

Can you not use a Pivot Table for this?

Hi cbatrody,

No I do not think that a Pivot Table will be enough. I need to be able to have three 'Drop Down' menu's next to each other. In each of these Drop Down menu's you should be able to choose from 10 to 20 different products. As soon as you have picked three prdoucts to compare than the specific data of these three products should appear in the designated cells. Do you understand what I mean or am I to vague hahahah?

Cordially,

BremmesN