I have attached a sample file to get the idea of what I am trying to accomplish.
In Column A there are Cities and in Column B there are product types.
I have created drop downs for the cities and product type. I want to enter a formula next to the drop down that will calculate the Final Map cost based on the city and product type in the data. I will also need to do the same for the data in the building column.
Is there a way for me to do this? I don't think VLookup works, but I thought maybe Index Match could do the trick. I have limited excperiance with those functions so I am not sure if that will work or if there is another trick that I am unaware of that will work.