Lesson · Excel for accountants
Lookups: matching invoices to payments
Use XLOOKUP to match receipts to invoices.
11 minutes Standard as at 3 November 2026
What you will be able to do
- Use XLOOKUP to match receipts to invoices
- Handle missing and duplicate matches
This is a preview of a member lesson. The full lesson is in the Excel for accountants library, open to everyone who enrols.
Free · one email a week
IFRS and SAM, one requirement at a time
Each week you get the Institute's new articles: one requirement of IFRS 17, IFRS 9, IFRS 15, IFRS 18 or SAM, worked on a South African case. You start with the free IFRS 18 readiness checklist, ten areas to work through before IFRS 18 takes effect, each with its paragraph reference.