Multiply with Vlookup value from another Worksheet
Greetings all,
Sorry if this has been answered before, but please kindly offer me some insight as to how to setup a proper formula for the following:
Basically, I would like to input a color in cell A2 on worksheet 1, which with vlookup it will display all the bas sub comp (A,B,C) & their weight from Worksheet 2 to be display onto cell D2-I2 on worksheet 1, which I have accomplished.
I would like to multiply the dynamic value in B2 with D2, F2, & H2 to give me the each weight of amount of comp A, B & C. However, after browsering though multiple formulas I cant seem to get it to work (pardon me for being an excel dummy).
Attached is the excel file I am working on.
Any advise is appreciated!
Best regards,
Mozie
|