Matching two different colums, VLOOKUP?
Try
=SUMPRODUCT((A2:A20="Printer")*(B2:B20="Canon")*(C 2:C20))
Mike
"Freddie" wrote:
Hi. I need to match 2 different variables (text), in this case a product
brand and a product category.
I know how to use vlookup to match 1 variable, but what formula do I use to
match 2 different values.
Example
Category Brand nbr of skus
Printer HP 3
Printer Canon 4
Printer Brother 2
I want to return number of SKUs if both category & brand matches.
/Freddie
|