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... 🕒 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... ⭐ *How To APPLY FILTER In EXCEL- Essential Skill* https://www.excelatwork.co.nz/2025/02... ⭐ *Find and Delete Duplicate Rows in Excel* https://www.excelatwork.co.nz/2024/05... 🔔 WEEKLY SUPER TIPS WEEKLY SUPER TIPS delivered directly to your inbox!: https://www.excelatwork.co.nz/subscri... 🔔 👨‍💻 Online Excel & Word Courses https://www.excelatwork.co.nz/self-pa... 📱 SOCIAL Let’s connect on social:   / excelatworknz   📣 Share this with someone who would enjoy this tip 🎉 #Exceltips #MicrosoftExcelTutorial #ExcelShortcuts #ExcelTraining #ExcelatWork #SharynBaines