I have two sheets 1 & 2. I’m to match customers from sheet 2 to 1.
I want to match by zip code and by name. If zip AND name of row(x) in sheet 2
Matches with zip AND name of ANY of the 5000+ row(s) in sheet 1 then highlight row(x) in sheet2. (to indicate a match)
If no match are found, then do nothing, and move on to next row of sheet2 until all rows of sheet2 are finished comparing to the sheet1.
Basically I need to compare TWO fields simultaneiously, (double match) per row to the respective TWO fields with the second sheet I am comparing too. If both criteria are meet then it is a match. Otherwise it is left alone/ignored. I want to do this for all 35000+ rows in my sheet2 which will take a long time without the help of a macro. Both the sheet to be worked on (sheet 2) and the sheet that exists only for comparison (sheet1) are huge and have many entries.
If anyone can help with the code that would be great!
Thanks
Bo
Bookmarks