View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Freddie Freddie is offline
external usenet poster
 
Posts: 6
Default Matching two different colums, VLOOKUP?

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