excelexcel-formulacomparevlookupaccounting

Comparing data in two columns in excel


The data

enter image description here

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... :(


Solution

  • 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.

    enter image description here

    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.