Compare two tables and generate a table with the data left over from the first table

Hello my first time here on the Forum, I hope you understand my problem and can help me.

I have two tables, Table 1 and Table Master, I need to generate a third table which contains only the data from Table 1 that is not found in the Master table.

I made a simple example. But the tables I’m going to use are huge, so I can’t check “row by row” because it would take too long in a FOR EACH.

I thought to compare the complete row of table 1 with the rows of the Master table, but that wouldn’t work because the master table has more columns.

what i need would be something with a LOOKUP and check if 4 columns are equal.

What can I do?

And now it seems incredible that I found the answer on this site myself.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.