multiple vlookups

I

inthestands

I need to compare matches for different months for customers and the
products
that they purchase. So I need to match three items; the customer, the
item,
and then check to see if the price has changed. Could you please help me

arrive at the answer that I have posted in the formula? Column.
Thanks in advance..

Jan Sales Feb Sales
customer item Jan price customer item Feb Price formula ?
Bill apple $1.00 Adam banana $2.55 new
Bill banana $2.00 Adam pear $4.30 new
Bill orange $3.50 Bill apple $1.20 $1.00
Bill peach $4.00 Bill banana $2.00 $2.00
Randy apple $1.05 Bill orange $3.30 $3.50
Randy banana $2.40 George apple $1.25 new
Randy cherry $3.60 Randy apple $1.05 $1.05
Randy grape $0.80 Randy banana $2.35 $2.40
Randy orange $3.75 Randy grape $0.90 $0.80
Randy tangerine $4.70 Randy orange $3.65 $3.75
Rick apple $1.00 Randy peach $4.50 new
Rick banana $2.50 Rick apple $0.95 $1.00
Rick peach $4.50 Rick banana $2.45 $2.50
Rick pear $4.20 Rick peach $4.50 $4.50
Rick pineapple $4.60 Rick pear $4.20 $4.20
Rick tangerine $5.00 Rick pineapple $4.60 $4.60
Tom apple $1.10 Rick tangerine $5.00 $5.00
Tom cherry $3.40 Tom cherry $3.30 $3.40
Tom grape $1.10 Tom grape $0.90 $1.10
Tom pear $4.40 Tom pear $4.40 $4.40
Tom pineapple $4.60 new

inthestands
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top