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
---
"Dream" wrote:
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

Thank you Max. It worked great

"Max" wrote:

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" wrote:
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

Welcome, glad to hear.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Dream" wrote in message
...
Thank you Max. It worked great