Composite Keys: Customer & Invoice, Stripped Prefixes and False Matches
This lesson is part of the course
In this lesson
You build a customer|invoice key on both sides, strip the INV- prefix from the statement references with RIGHT and LEN, and show that matching on the invoice number alone hides two missing invoices.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Match or Missing: COUNTIF in Both Directions & Status Flags Locked
- Composite Keys: Customer & Invoice, Stripped Prefixes and False Matches Locked
- Duplicates Inside a List: COUNTIF, First Occurrences and Inflated Totals Locked
- Changed Values: XLOOKUP the Other List and Flag Each Field Locked
- Tolerance Matching: Amounts Within a Few Cents and Dates Within N Days Locked
- Partial Keys: Matching on the First Characters and Finding Numbers Inside Text Locked
- The Reconciliation Summary: Totals A vs B, Explained and Unexplained Differences Locked
- The Exception Report: A Numbered List of Every Open Item Locked