workable sheet with adjusting prices

Hi,

I'm a contractor of drywall. I'm trying to make a worksheet where i can input my total mē of to do drywall and that tells me what the material cost is.
Of course there are different kinds of drywall and all with different sizes.
So basically my sheet has a setup like this: a cell where i can input the mē, a drop-menu with the kinds of drywall, next to that a drop-menu with available sizes in that specific drywall and at last the price.
I can get the kinds of drywall in a drop-menu and also the specific sizes but i can't figure out a way to get the price.
Later in want to expand my worksheet so that it also tells me how many studs, screws etc. and then a total price of material cost.

Anyone know a good way to get this achieved?

Regards,

Tom

Thanks but the problem i have is when i choose another size or type the price needs to change. Every type of drywall has another price. So depending on the choice in the drop-menu the price changes.

VLOOKUP was the way to go.

Many thank mate!

Great. Best to you.