Find item in list by referencing two conditions

  • Thread starter Thread starter Cornelius
  • Start date Start date
C

Cornelius

Hi. Let me explain the sheet: I have a list of weekly
sales, with each row containing a salesman number, a
product code, and a weight of the product sold. Different
salespeople can sell the same product, but have different
entries.

Now I am trying to get a series of worksheets for each
salesperson that tallies their weekly sales by product.
Not all products are sold each week, but I do need zeros
for the unsold products on each salesperson's sheet, which
contains every possible product code.

I am trying a Vlookup/IF combo after failing to comprehend
DGET, which purports to be able to do this. The code I
have so far:

=IF(VLOOKUP(A5,MASTER!AI6:AL1066,4,FALSE)=$A$3,VLOOKUP
(A5,MASTER!AI6:AL1066,2,FALSE),"0")

Which looks to see first if a row matches the sales number
(A3 in first Vlookup), the if it does so looks for a
weight to match the code, or if not produce a zero.
Column A has the product codes trying to be
found. 'Master' has the lists of data, with AI as
salesman, AJ as product code, AK as weight.

I can't quite figure out how to match the row found in the
first Vlookup to the second, I can only return the first
weight of the product code

Any ideas? Thanks very much in advance.

Cornelius Cremin
 
Back
Top