Different prices per design and size, how to extract the correct price to another sheet?

[paulareiblue]

Hi!

Can anyone help me figure out how to get the right price for items that has different price points depending on design and size? I'm trying to get the warehouse price on the Website Sheet by getting the data from Price List sheet. I need to multiply the cost price (website sheet) to the corresponding price from the price list sheet to get the warehouse price.

I hope someone can help me, because I'm having a hard time figuring this out and I need to do 50,000 products. Thank you all in advance!

[Mazzaropi]

Paulareiblue, Good evening.

Please, what are the correct answers that you expect to receive for your 2 examples?

1) 10026691 - 10x14 - Camber - ????? (6013.44)
2) 10031540 - 10x14 - Artic - ????? (6883.50)

Waiting your answer.

[paulareiblue]

Hi,

Thanks for your response. You are correct. For this example, in reference with the price list sheet, the answers for the warehouse price will be:

1) 10026691 - 10x14 - Camber - 6013.44
2) 10031540 - 10x14 - Artic - 6883.50

Paulareiblue, Good evening.

Please, what are the correct answers that you expect to receive for your 2 examples?

1) 10026691 - 10x14 - Camber - ????? (6013.44)
2) 10031540 - 10x14 - Artic - ????? (6883.50)

Waiting your answer.

[Mazzaropi]

Paulareiblue,

Try to use it:

D2 --> =C2*VLOOKUP(J2,'Price List'!$A$2:$I$4,MATCH(I2,'Price List'!$A$1:$I$1,0),FALSE)
Copy it down.

Is it what you want?
I hope it helps.
-------------------------
Belo Horizonte, MG - Brazil

[paulareiblue]

Mazzaropi,

Yes it worked!!Thanks a bunch!

Paulareiblue,

Try to use it:

D2 --> =C2*VLOOKUP(J2,'Price List'!$A$2:$I$4,MATCH(I2,'Price List'!$A$1:$I$1,0),FALSE)
Copy it down.

Is it what you want?
I hope it helps.
-------------------------
Belo Horizonte, MG - Brazil