Comparing data in two columns in excel

Question

The data

I need a formula to find out if column 1 has a pair in column 2.

The aim is to find the value that does not have a pair.

I have 4,333 rows of data and doing it manually would take me hours.

I tried

=VLOOKUP(A2,$B$2:$B$5,1,0)

but somehow it did not work... :(

Answer 1

The best formula helps you is a single-cell formula

[C1]=XMATCH(A1:Axxxxx,B1:Byyyyy)

where xxxxx - the last row in A, yyyyy - the last row in B.

In this solution, for each element in the first column, XMATCH displays the matched element from the second column or #N/A if no match found.