Auto fill Formulation sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3014548%22%20slang%3D%22en-US%22%3EAuto%20fill%20Formulation%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3014548%22%20slang%3D%22en-US%22%3E%3CP%3EIm%20looking%20to%20create%20a%20table%2Fform%20where%20you%20can%20select%20from%20a%20drop%20down%20a%20product%20and%20it%20auto%20fills%20some%20cells%20with%20data%20from%20another%20table.%26nbsp%3B%20Ive%20made%20the%20base%20of%20the%20table%20but%20im%20having%20trouble%20getting%20the%20total%20values%20to%20change%20depending%20on%20what%20%25%20each%20raw%20material%20should%20be.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20each%20raw%20material%20will%20have%20a%20base%20value%20per%20product%2C%20so%20it%20might%20use%20the%20same%20raw%20materials%20but%20use%20a%20different%20base%20value%20in%20%25.%20i%20would%20like%20this%20to%20reflect%20in%20the%20total%20next%20to%20each%20raw%20material.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eive%20tried%20my%20hand%20at%20it%20but%20im%20now%20stuck%20and%20would%20appreciate%20some%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel%20formula.png%22%20style%3D%22width%3A%20865px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F330048i499831ADE7EAE68F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel%20formula.png%22%20alt%3D%22excel%20formula.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3014548%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3014861%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20fill%20Formulation%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3014861%22%20slang%3D%22en-US%22%3EBetter%20to%20post%20an%20anonymized%20copy%20of%20your%20file%20with%20perhaps%20just%20one%20or%20two%20nonsense%20products%20and%20tell%20us%20what%20you%20expect%20it%20to%20contain%3C%2FLINGO-BODY%3E
New Contributor

Im looking to create a table/form where you can select from a drop down a product and it auto fills some cells with data from another table.  Ive made the base of the table but im having trouble getting the total values to change depending on what % each raw material should be.

 

so each raw material will have a base value per product, so it might use the same raw materials but use a different base value in %. i would like this to reflect in the total next to each raw material.

 

ive tried my hand at it but im now stuck and would appreciate some help.

 

 

 

excel formula.png

1 Reply
Better to post an anonymized copy of your file with perhaps just one or two nonsense products and tell us what you expect it to contain