Looking for help with adding formulas to a drop down menu!

I'm looing for some assistance. I have created a spreadsheet and have five columns for different models of furnaces. Within those five different columns, I have dropdowns where a Project Manager can choose a different size of furnace which can have almost ten difference choices. When the PM chooses the furnace he/she wants, I would like it to automatically populate with a price that I have connected to it (for as little room for error as possible), but I don't know how to get that connection. I have each dropdown in just one cell (ie D54) Thanks in advance for any help!