Forum Discussion
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...
To make Table 3, you are just adding the Warehouse to Table 2. So insert a column before Table 2 (I call it A, such that Product Name is in C) and before Fruits/Apple write (conceptually):
=XLOOKUP(Table2[ProductName];Table1[ProductName];Table1[Warehouse])
That should populate the entire Warehouse column. (Product Category does not seem to inform your mapping.)
=XLOOKUP(Table2[ProductName];Table1[ProductName];Table1[Warehouse])
That should populate the entire Warehouse column. (Product Category does not seem to inform your mapping.)