Xlookup or other formula help for copying data over but excluding specific data

[jimmy2335]

I have sheet A that has 3000 rows of data, and I have sheet B that has 1000 rows of data. I want to copy all data from sheet A to a new sheet, sheet C, but exclude all rows that are in Sheet B. Sheet B consists of data that is in sheet A that I do not want in there so I'm not sure the best way to exclude/filter that sheet B data out. Any help is appreciated, thank you!

i.e. if sheet C includes any data from sheet B, remove/do not include that row.

[#2 · Accepted solution]

@jimmy2335 

Let's assume that you want to exclude rows that match on column A.

In A2 on Sheet C:

=FILTER('Sheet A'!A2:Z3000, ISNUMBER(XMATCH('Sheet A'!A2:A3000, 'Sheet B'!A2:A1000)))

Adjust the sheet names and the ranges as needed.

[#3]

Thank you! I was able to get it from this, appreciate it.