Compare multiple columns & rows in tables for matches

What I'm trying to do is have a VBA or formula to compare the data between multiple columns in two tables to make sure all data matches, but I wanted to see if there was an easier way to do it besides hiding columns that do individual checks for each cell and then having the final output be a count if function and output a yes or no based off matches. Ideally it would be a one cell formula that doesn't need to rely on anything but the data but let me know if it's possible or if my original plan is easier.

For further details, here's what I'm looking for.

• exact matches between two cells down to row 150 for multiple columns. Only 3 columns between the 2 tables are needed to be matched
• i.e. (C1 = I1, D1=J1, E1=K1), etc, and it checks each row for this down to row 150
• potentially to ease things cells that don't need to be checked are empty
• If all data matches it outputs a "yes", if there is greater than or equal to 1 mismatch then it outputs "no"

Any help is appreciated!

Made a quick example that should hopefully show what I'm trying to do better

Your solution was close but helped me realize I overlooked a very simple solution that I could have done. I changed it to sum table1 minus sum table2 and if they don't equal 0 then I get the error. Thanks!

Formula:

Please Login or Register  to view this content.