Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiple vlookups
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple vlookups | Excel Worksheet Functions | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) | |||
multiple entries | Excel Worksheet Functions | |||
Vlookups and multiple returns (again!) | Excel Worksheet Functions |