Originally Posted by
whftherb
Got it (Actually, you did...) Sorry to be so unskilled with this...
But -
I'm beginning to see where my not thinking this through is a big part of the problem in terms of clearly idenitifying the issue.
This function compares Sheet2:A1, Sheet2:B1 with its corresponding positioned cells at Sheet1:A1, Sheet1:B1. Fine and it does that well. In my real word case, Sheet1 could have 20000 rows while Sheet2 could have only 500 rows. The expectation is that many of the Sheet2 cell pairs won't have matches in Sheet1 - but - can't take that to the bank...I have to ensure they're found if they exist.
Question: Let's assume the matching target cell pair just so happens to be positioned at Sheet1:A91, Sheet1:B91? This solution won't MATCH Sheet2:A1, Sheet2:B1 by "searching" through Sheet1:ColA paired with sister cells Sheet1:ColB and pull out the corresponding match, right?
Isn't this then calling for a greater amount of programming sophistication (like VBA???) to search and put an x whenever and wherever a matching cell pair is found no matter where it is found in ColsA/B of Sheet1?
Bookmarks