Crossposted from here, with some editing to the below version to clarify what I'm trying to do. I hope that this is OK, I'm new!

Hello,

There has got to be a name and a formula to do what I'm trying to do, I just know it! Hopefully one of you smart, helpful folks will be able to assist me.

I am creating a budget proposal with various ranges of data, and wanting to have some cells that react to certain changes. So, for example on total food cost, instead of having to create multiple row sections of how much things would cost for 150 people, 200 people, etc, I would like to have a drop-down list in a cell titled "number of guests," and then have my range of expense rows, "Breakfast," "Lunch" etc., change to reflect the number of
guests (or whatever) being chosen. (My columns are "anticipated budget," "actual," and "Difference," in case that matters.)

I hope I'm making sense! Is this something that is even possible to create?

Thank you for any help at all!