I need to create an excel spreadsheet that works sorta like an interactive form on the web. I have dropdown menus in excel for example a lot number for a house, drop down for the house plan, dropdown for counter tops .. etc. Each of these choices in the drop down has a price associated with it. Id like to be able to populate a cell with these prices based on the dropdown selection so I can add a formula in for total cost based on several different drop down configurations. A makeshift effort is attached. I have figured out the dropdown menus, just not sure how to link their selections to and populate another cell.
Thanks in advance,