How to make more data appear on sheet once selections are made from drop down lists!

Somebody please help me as I don't have any more hair to pull out! Excel Newbie. Here's what I am trying to do:

I have a drop down list that gives uses choice of party size, let's say (1,5,10,15 or 20 persons).

The second drop down menu has list of brands of glasses that they can choose (Brand A, B, C, D). What needs to happen is that once the person selects how many persons and what brand they want, data appears below with the quantity/price/item number etc. based on how many persons and what brand they chose. The data that is to appear is over multiple lines and columns. I have figured out how to make drop down lists using data validation.

They must choose brands of glasses, plates, and silverware.

Can someone help? I would really appreciate it! Happy New Year everyone!

Might want a sample doc, having a hard time picturing it.

I have done sheets that will use multiple drop downs and do vlookups based on whats been selected.

So vlookup to look up based on teh brand selected, multiplied by the quantity selected, for each data point you want included.

And you can always build on that, so "IF(Cell=Brand A,a4*b4,if(Cell=Band B, etc etc

Make sense?

~James

~James

Hi James, Thank you! I should have added, the data quantity/price/item# etc. are not necessarily direct multiples of the number of people, so "a4*b4" in not workable. I would rather just have the pre-calculated data default below the drop down list based on their selection. So let's say they select 5 people from first drop down list and then Brand A of glasses. This would default data like 12 dozen hi-balls, 1 dozen shot glasses, etc. It doesn't need to calculate the data, only paste it below based on their drop down list selections. Does that make sense? Thank you again James! Cheers!

Not sure how your table is set up, or if it's in progress. What pops to mind for me is something to the effect of IF(Quantity=5,vlookup(Brand,quant5table,info you need),if(quantity=10,vlookup(brand,quant10table,infoyouneed))

So basically you'd have a table for you quantities, containing the data for each possible brand, and the looks ups will will go "ok it's quant=5, thats this table to look up the brand..." and the false for each IF is the next possible quantity containing the vlookup for that quantites table.... with the last false being something like a "" so it delivers a blank if it hasnt found any that work.

Am I making sense?

~James