Excel - Multiple vlookup

[mike_2011]

Hi there,
I have the problem to multiply data entries.

columnA_Volumes (A1:100, A2:300, A3:500)
columnB_Percent (B1:5%, B2:20%, B3:50%)

columnC_Rates (C1:992, C2:994, C3:996)
columnD_Percent (D1:53%, D2:36%, D3:87%)

columnE_Combi (columnA&columnC) all possible combinations

The percentages in column_B & column_D are manual input. I am looking for a formula that looks up all the different combinations from column_E wherby the percentages are looked up and multiplied from both columns_B&D
(e.g. for a combination of 100994 lookup 5% and multiply it with 36%).

Could you please help me with this?
Many thanks in advance!
Best,
Mike

[EINSTEIN_007]

I think that you can use the Pivot Table feature, with the date across the top and the code along the side. Then bring up the properties for the body of the table and select the formula you want. You could also try to use cell links such as
='master sheet'!A1
in your target cells