Band Lookups: Approximate Match on Lower Bounds, Open Top Bands, Gaps & Overlaps
This lesson is part of the course
In this lesson
You look up the band and the unit price of six orders on Larkspur's price list with an approximate-match XLOOKUP and INDEX/MATCH, then check a partner's hand-typed band table for gaps and overlaps.
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
- Band Lookups: Approximate Match on Lower Bounds, Open Top Bands, Gaps & Overlaps Locked
- All-Units Tiers: One Rate for the Whole Quantity, Cliffs & Buying Up to the Next Band Locked
- Incremental Tiers: Units per Band, One SUMPRODUCT & the Effective Rate Locked
- Block Tariffs: Fixed Charge, Rising Blocks, Bills for Many Sites & the Marginal Price Locked
- Volume Rebates: Retroactive vs Prospective Scales & Accruing from a Year-End Forecast Locked
- Tiered Commissions & Fee Tables: Accelerators, Fixed + Percent Fees & the Effective % Locked
- Stepped Fixed Costs: Staff Added Every N Units, Cost per Unit & the Best Operating Points Locked
- A Tier Engine: One Band Table, One Formula for Every Customer & Two Price Lists Compared Locked