Hi Everyone,
I have a workbook with 2 sheets(Import & Total Sales). In the Total Sales sheet, Cell B2 there is a UPC
(028200004222/003). I want to lookup that UPC in the Import Sheet, Column B and return the number sold from Column
D to the Total Sales sheet, cell C2 . In this case there are a total of 3 UPC's that match for a Sum of 3(1 each). Obviously
my Dlookup only finds the first one in the list so I need a Count & Sum function I'm guessing??
Thank You!!
I have a workbook with 2 sheets(Import & Total Sales). In the Total Sales sheet, Cell B2 there is a UPC
(028200004222/003). I want to lookup that UPC in the Import Sheet, Column B and return the number sold from Column
D to the Total Sales sheet, cell C2 . In this case there are a total of 3 UPC's that match for a Sum of 3(1 each). Obviously
my Dlookup only finds the first one in the list so I need a Count & Sum function I'm guessing??
Thank You!!
Code:
=IFERROR(VLOOKUP(A2,Import!$B:$E,4,FALSE),0)