I am working in excel 2010. I have a list that I am using multiple times in a drop down list. I want a way to do a calculation based on the choice the user used. Item Value
The user can choose the truck or car in various cells of the sheet. I then want a total value based on their text choice2.