I am trying to get a list of items that match on two criteria.
DATE PRODUCT CHANNEL
DEC 13 Cat Chow DRUG
NOV 13 Pupperoni DRUG
DEC 13 Meow Mix DRUG
DEC 13 Jerky Treats DRUG
This is the data from A1 to C5. I want all the product sold on DEC 13 and in the DRUG channel. This is the formula that I have now, which is only bringing back the first example.
INDEX($B$2:$B$5, MATCH(1, ("DRUG"=$C$2:$C$5)*("DEC 13"=$A$2:$A$5), 0) )