How To Compare Two Tables In Excel (Full Guide\ All ways)

How To Compare Two Tables In Excel.

simple comparison:
=IF(C3=D3,"","No")

Comparing three columns:
=IF(AND(B3=C3,B3=D3),"Full match","")
=IF(OR(B3=C3,B3=D3),"match","")

Using the vlookup function:
=VLOOKUP(G4,$C$4:$D$13,2,FALSE)

00:00 - Hello
00:10 - A simple comparison
00:52 - A simple comparison (with IF function)
01:46 - Using conditional formatting
02:30 - Comparison without using formulas
02:53 - Comparing three or more columns
03:54 - Using the vlookup function
05:51 - Using a pivot table
08:20 - The most advanced way, using the "Power Query" tool
12:44 - Adding new items to the comparison table

[tomtom]

This is awesome! Such range as well. Thank you