Matching Two Lists: Exact Keys, Amount & Date Tolerances and First-Match Rules
This lesson is part of the course
In this lesson
You match seven bank lines with six open invoices: by exact reference, by counting candidates within an amount and date tolerance, by returning the first candidate with XLOOKUP, and with a running count that shows which lines share an amount.
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
- Running Totals as the Engine: Cumulative Amounts, What Is Left & Where It Runs Out Locked
- FIFO Payments to Invoices: Oldest First, Allocated Amounts, Open Balances & Part-Paid Flags Locked
- Several Payments, Several Invoices: Running Totals on Both Sides & the Allocation Matrix Locked
- Stock to Orders by Priority: Rank by Two Keys, Demand Ahead & Filled, Part or Zero Locked
- Fair-Share Rationing: Proportional Shares, Whole Units & the Largest-Remainder Rule Locked
- Capacity Allocation: Jobs into Days in Sequence, Finish Days, Dates & Overflow Locked
- Matching Two Lists: Exact Keys, Amount & Date Tolerances and First-Match Rules Locked
- Allocation Dashboard: Unallocated Cash, Check Totals, Exceptions & a Chart Locked