How to Compare two columns with Excel
You can easily compare two columns in Excel with the function VLOOKUP or the function XLOOKUP. You can also add a conditional format to highlight the differences
https://excel-tutorial.com/compare-2-...
00:00 Intro
00:34 VLOOKUP function
01:50 XLOOKUP function
02:27 Remove the N/A with ISNA
03:01 Change the color of the cells