VLOOKUP combined with if function

**Tina B** · 02-23-2009, 05:05 PM

Hello! I have 2 spreadsheets that I am working on that I need to use the same type of formula.

in the First sheet I have a price list table set up
in second sheet I have a customer list

What I need to do is I need to find the fixed price.
I was trying to use if and vlookup but I must be doing something wrong.

If cell C2 is 2007 look up item in B2 in the pl (price list table) and enter contents of the cell*E2 or if C3 is 2008 same thing and 2009 same thing.

Please help. I attached the sheet. Thanks for your help!

**DonkeyOte** · 02-23-2009, 05:26 PM

If I've understood

CUSTOMER!D2:
=VLOOKUP($B2,'Price list'!$A$1:$D$7,MATCH($C2,'Price list'!$A$1:$D$1,0),0)
copy down

**Tina B** · 02-24-2009, 10:12 AM

WOW That was a quick response. Thanks so much for your help. Just one more thing. How would I add to that formula to multiply the result, by contents in cell E2 in the customer sheet?

**NBVC** · 02-23-2009, 05:27 PM

Try:

=INDEX(PL,MATCH(B2,'Price list'!$A$1:$A$7,0),MATCH(C2,'Price list'!$A$1:$D$1,0))

copied down.

**NBVC** · 02-24-2009, 10:14 AM

Just add *E2 to the end:

=INDEX(PL,MATCH(B2,'Price list'!$A$1:$A$7,0),MATCH(C2,'Price list'!$A$1:$D$1,0))*E2

**Tina B** · 02-24-2009, 10:20 AM

You guys are amazing! Thanks for everything.

**NBVC** · 02-24-2009, 10:23 AM

You are most welcome.

Can you please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save