How to Compare two columns with Excel

Published: 18 April 2021
on channel: Excel Exercice
18,516
96

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.