Drop down list to auto-populate fields and multiplied by another field

Originally Posted by NBVC

See if the attached helps.

I am assuming only one dropdown selection per your sample.

I separated you data into separate cells so they can be more easily looked up.... and then applied formula in E8:

=IF(AND($C8=$B$2,ISNUMBER(MATCH(E$7,INDEX($T$6:$AD$9,MATCH($B$2,$S$6:$S$9,0),0),0))),$C$2,"")

copied down and across the table.

you can make the T6:AD9 and S6:S9 ranges as wide as you want to include more possible "food"

This is perfect!! One last thing if you don't mind, what would the code change be if I wanted to have X number of boxes?