How to multiply a number by a set of numbers

  • Thread starter Thread starter Dream
  • Start date Start date
D

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
 
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
 
Thank you Max. It worked great

Max said:
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
Click to expand...
 
Back
Top