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
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
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
This has the same options you show, and then has a formula that uses these drop-down options to determine a value.
example.xlsx
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
Thanks
PFTdaily-schedule-2015.xlsx
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.
But if your drop-down list in column B, then try this.....
=VLOOKUP(B7,Sheet1!$A$2:$B
and then copy down.
Is this what you are trying to achieve.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very fast and extremely helpful.
THANKS!!!
THANKS!!!
ASKER
Just had to tweak it a little.
Thanks
Thanks
You're welcome. Glad I could help.
If you are not able to fix this yourself, a sample workbook with desired output filled manually would help.