Changed Values: XLOOKUP the Other List and Flag Each Field
This lesson is part of the course
In this lesson
You fetch this month's price for every SKU with XLOOKUP, flag which fields changed, count the changed fields per SKU and count the SKUs with any change.
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