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.