Forum Discussion

waterding's avatar
waterding
Copper Contributor
Jul 13, 2022

How do I join two tables in Excel?

I have Table 1 and Table 2. How do I use formulas/pivot table to match Product Category and Product Name between Table 1 and Table 2, and come up Table 3?   Table 1 Warehouse         Product Categ...
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Jul 13, 2022

waterding 

 

 

in M4:

=SUMIFS(Table2[Quantity],
        Table2[Product Category],[@[Product Category]],
        Table2[Product Name],[@[Product Name]]
)

 

Resources