I have a spreadsheet with trade agreement prices and units of measure. I
need to match the trade agreement sheet with a sales history sheet to see if
items were sold at, below or above the trade agreement price. I also need to
see if the unit of measure on the sales order is the same as the trade
agreemt. The trade agreement sheet has Customer inv #, Customer acct#, Part
number, price and unit of measure. An invoice account can have mutliple
account numbers and for each account number the part numbers and price are
repeated. I was able to get the price over onto the sales history sheet
using sumproduct, but I can't do the same thing with the unit of measure.
Vlookup doesn't work. Do you have any suggestions?
