Use vlookup on the table like:

=if (isna(vlookup(A1,sheet2!a1:b35000,1,false),"no match","match")

if the column a contains the unique key, otherwise adjust as required or add
a column and make the key.
--
HTHs Martin


" wrote:

Hi,

I have 2 tables and i need to get the unmatches between the 2 tables
(fast way because its a long tables ~35000 rows)

thanks for help.