I'm new to this forum but have been using the website a long time. You guys are a great help.
Here is my problem that I hope someone can help me figure out:
The spreadsheet contains two different tabs.
First tab:
______product1 product2 product3 product4 product5...
name1
name2
name3
Second tab:
name1 product1 amount
______product2 amount
______product3 amount
______product4 amount
______product5 amount
name2 product1 amount
______product2 amount
______product3 amount
______product4 amount
______product5 amount
name3 product1 amount
______product2 amount
______product3 amount
______product4 amount
______product5 amount
Is there a way I can pull the amount from the second tab into the first tab if the name and the product match up? I am getting confused because it is column and row criteria on the first tab vs a two column criteria on the second tab.
Anybody know how to make this work? I've tried sumif, sumproduct, vlookups, hlookups and match's. I can't seem to get it. Please help!
Here is my problem that I hope someone can help me figure out:
The spreadsheet contains two different tabs.
First tab:
______product1 product2 product3 product4 product5...
name1
name2
name3
Second tab:
name1 product1 amount
______product2 amount
______product3 amount
______product4 amount
______product5 amount
name2 product1 amount
______product2 amount
______product3 amount
______product4 amount
______product5 amount
name3 product1 amount
______product2 amount
______product3 amount
______product4 amount
______product5 amount
Is there a way I can pull the amount from the second tab into the first tab if the name and the product match up? I am getting confused because it is column and row criteria on the first tab vs a two column criteria on the second tab.
Anybody know how to make this work? I've tried sumif, sumproduct, vlookups, hlookups and match's. I can't seem to get it. Please help!
