How to multiply a number by a set of numbers

[Dream]

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

 

[Max]

In Sheet1,
you could place something like this in D1
=IF(VLOOKUP($C1,Sheet2!$A:$Z,COLUMNS($A:A)+1,0)=0,"",$B1*VLOOKUP($C1,Sheet2!$A:$Z,COLUMNS($A:A)+1,0))
Copy D1 across as far as required, fill down to populate
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Dream]

Thank you Max. It worked great

In Sheet1,
you could place something like this in D1:
=IF(VLOOKUP($C1,Sheet2!$A:$Z,COLUMNS($A:A)+1,0)=0,"",$B1*VLOOKUP($C1,Sheet2!$A:$Z,COLUMNS($A:A)+1,0))
Copy D1 across as far as required, fill down to populate
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Max]

Welcome, glad to hear.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik