Greetings all,

The question I am about to ask might have been answered before, but please bear with me as I have gone through multiple threads and cannot seem to get a through understand on how I should make the formula.

Basically I have setup a VLOOKUP on worksheet 1 to look up the different comp & its weight on worksheet 2 when I input the color in A1 in worksheet 1. I would like to have the VLOOKUP value of D2 to be multiply by to dynamic value in B2 to give me the result in D3. I cannot seem to get it to work (I am an excel dummy!).

Please offer your advises or insights which can help me with this mind bobbling formula. I have attached the excel file here. cal3.xls

Thank you in advance!

best regards,

Mozie