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
Watch video How to Compare two columns with Excel online without registration, duration hours minute second in high quality. This video was added by user Excel Exercice 18 April 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 18,516 once and liked it 96 people.