Forum Discussion

LHeidel's avatar
LHeidel
Copper Contributor
Sep 08, 2023

Help with Formula for Customized Calculator

Hello!

 

I am in the process of creating a custom calculator. I have a list of items that we use at my job and their weights next to each corresponding item. I've already created the dropdown list of the items using data validation. What I need assistance with is how to create a formula that will allow me to figure out the total weight of items depending on which item on the dropdown list was chosen.

 

For example, if "Bath Blanket (white)" was chosen, then the value would be the weight of one bath blanket multiplied by whatever number they enter in the cell next to the dropdown. Let's say the bath blanket weighs 660g and they enter 2 in the cell next to the dropdown list... I want the "Total Weight" cell to be 1,320g.

 

Help!

 

1 Reply

  • LHeidel 

    =IFERROR(B8*VLOOKUP(A8,$G$8:$H$1000,2,FALSE),"")

    You can try this formula. The formula is in cell C8 and filled down to cell C12.

Resources