| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup and sum of colums | Excel Discussion (Misc queries) | |||
| Vlookup Fixed reference but move on colums Ref# | Excel Worksheet Functions | |||
| VLOOKUP for multiple colums | Excel Worksheet Functions | |||
| Get matching values and formulas from ajoining colums of dropdown | Excel Discussion (Misc queries) | |||
| match to colums vlookup | Excel Discussion (Misc queries) | |||
Threaded Mode
