ListBox Query

[mgm05267]

Hi...

I have 3 list boxes for which for 2 list boxes items are being added from the sheet.

For the 3rd list box, I need items to be added by multiplying the values of List 1 & list 2 corresponding items.

Ex:
List1 has 2, 4, 6 (3 items)
List2 has 3, 5, 7 (3 items)
then,
List3 should be 6, 20, 42 (3 items)

as the range are dynamic, values should populate automatically..

Is there any way to do this..???

Please help..

 

[mgm05267]

Any Ideas...!!??

 

[mgm05267]

Any Ideas....????