Hi all
I appreciate your help on the following

In sheet1, i have
A $200 3
B $400 5
C $600 6

in the second sheet I have
3 30% 40% 30%
4 20% 30% 30% 20%
5 10% 20% 20% 20% 20% 10%
6 10% 10% 30% 30% 10% 10%

i would like excel to do the following, to produc e the followign in the
sheet3
project A 30%*$200 40%*$200 30%*$200
so it becomes
project A $60 80$ 60$

the idea is, for project A, to check the number next to the cost, in tehis
case 3, then goes to sheet 2 and check for the row that starts with 3, then
copyt the entire row infront of proejct A after multiplying each cell with
the project cost (in this case 200) and spill out the result in adjacent cells

Thanks in advance