HOW TO Compare Two Lists in EXCEL Using XLOOKUP

If you have two Excel lists that should match — such as customer invoice payments and your own records of what was received — this video shows you how to compare two lists in Excel using XLOOKUP, so you can quickly find missing invoices and mismatched values without scrolling or manual checking. ✅ In this Excel tutorial, you’ll learn how to: - Use XLOOKUP to match invoice numbers across two worksheets - Bring the customer’s payment amount into your own list for comparison - Replace #N/A errors - Use a simple IF formula to flag values that don’t match - Reverse the XLOOKUP to find invoices missing from your records This is a common real‑world Excel task I see all the time, and XLOOKUP makes it much easier than older methods like VLOOKUP. 📥 Download the practice file and read the full step‑by‑step guide here: 👉https://www.excelatwork.co.nz/2026/03/01/how-to-compare-two-lists-in-excel-using-xlookup/ 🕒 Chapters: 00:00 How to compare two lists in Excel using XLOOKUP 00:18 The two lists we’re comparing 01:22 Build the XLOOKUP to match invoice numbers 03:50 Replace #N/A errors with the word “missing” 04:50 Use IF to flag mismatched amounts 05:48 Optional: identify overpaid and shortpaid invoices 06:17 Reverse XLOOKUP to find invoices missing from your list 07:59 Identifying data entry errors (mis‑keyed invoice numbers) 08:32 Final recap If you found this helpful, let me know in the comments. 🎬 For more practical Excel tips you can use at work, subscribe to my channel. ** Related videos: ** ⭐ **Excel – Using VLOOKUP to compare two lists** https://www.excelatwork.co.nz/2017/06/20/excel-using-vertical-lookups-to-reconcile-accounts/ ⭐ **How To APPLY FILTER In EXCEL- Essential Skill** https://www.excelatwork.co.nz/2025/02/10/how-to-apply-filter-in-excel/ ⭐ **Find and Delete Duplicate Rows in Excel** https://www.excelatwork.co.nz/2024/05/06/find-and-delete-duplicate-rows-in-excel/ 🔔 WEEKLY SUPER TIPS WEEKLY SUPER TIPS delivered directly to your inbox!: https://www.excelatwork.co.nz/subscribe-eawi-weekly-tips/ 🔔 👨‍💻 Online Excel & Word Courses https://www.excelatwork.co.nz/self-paced/online-excel-courses-nz/ 📱 SOCIAL Let’s connect on social: https://www.facebook.com/excelatworknz 📣 Share this with someone who would enjoy this tip 🎉 #Exceltips #MicrosoftExcelTutorial #ExcelShortcuts #ExcelTraining #ExcelatWork #SharynBaines