Avatar of BOULMAN
BOULMAN
 asked on

Calculating a total value based on weighted drown list

Hello Experts
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
                                                                                                 Truck      2
                                                                                                 Car          1
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.

Any suggestions?
Thanks
Jarrod
Microsoft Excel

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
Subodh Tiwari (Neeraj)

Try SUMIFS.

If you are not able to fix this yourself, a sample workbook with desired output filled manually would help.
Jon Covalt

I've create a sheet with a basic IF formula to accomplish what you want. The trouble with this is that if you have a lot of drop-down options, the formula can get too long (you're limited to a certain number of statements, though it's pretty long).

This has the same options you show, and then has a formula that uses these drop-down options to determine a value.
example.xlsx
BOULMAN

ASKER
I think that is on the right track but here are the two sheets I am using.  I my only have 1 or 2 more choices.

Thanks
PFTdaily-schedule-2015.xlsx
Your help has saved me hundreds of hours of internet surfing.
fblack61
Subodh Tiwari (Neeraj)

Not sure exactly in which column you want the formula and you haven't added the desired output as well.
But if your drop-down list in column B, then try this.....

=VLOOKUP(B7,Sheet1!$A$2:$B$12,2,0)
and then copy down.

Is this what you are trying to achieve.
BOULMAN

ASKER
My hope was to have each drop down cell be linked to a value based upon what was picked.  Then either have a lab total or just a grand total from the three areas.  Not quite sure where to put the vlookup.
I filled out the sheet and manually entered the values.  That might help me explain what I need.
PFTdaily-schedule-2015.xlsx
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
BOULMAN

ASKER
Very fast and extremely helpful.
THANKS!!!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
BOULMAN

ASKER
Just had to tweak it a little.
Thanks
Subodh Tiwari (Neeraj)

You're welcome. Glad I could help.