Sumproduct and Vlookup
 

Can they be combined?

Sumproduct and Vlookup
 

Hi,
What do you want to achieve ?

"Richard" wrote:

Can they be combined?

Sumproduct and Vlookup
 

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?

"Eduardo" wrote:

Hi,
What do you want to achieve ?

"Richard" wrote:

Can they be combined?

Sumproduct and Vlookup
 

Hi Richard,
Please send to me an example, two or three lines of both sheets, you should
be able to pull the information using sumproduct

"Richard" wrote:

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?

"Eduardo" wrote:

Hi,
What do you want to achieve ?

"Richard" wrote:

Can they be combined?