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?
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.
