I have two columns in two sheets each. I would like to compare those two columns for any match and where both columns have a match I would like to add the corresponding values in third column in one of the sheet.
Attached is an example of what I am looking to do.
Sheet 1 has three columns. I would like to match sheet1:columns with sheet2:row2 data (same color) AND sheet1:column2 data with sheet2:row1 data and for every instance where both match, I would like to add up sheet1:column3 entries.
After looking through this forum I though sumproduct can do this. My try in sheet2:cellN2 but problem is AND condition returns 12 enteries that it tries to multiply with single entry from sheet1:column3.
I guess what is making this complicated is that I would like to match each entries from sheet2 rows with corresponding columns and find all the matches not just one or first match.
This file is a very small version of my actual problem. On sheet1 I have 20,000 rows and on sheet 2 I have close to 300 double rows that I need to match (I am hoping to copy the formula down). So any split second efficiency will be big help also.
Does anyone have any solution or suggestion?
Jay
Bookmarks