Essentials · Formulas

Lookups

4 lessons and 56 marked steps, with a workbook to open in Excel alongside. Your first two lessons on LogicExcel are free with a free account; after that every lesson opens with the All-Access Pass.

1. 1. XLOOKUP exact matchAll-Access Pass

   Retrieve route and trip attributes with XLOOKUP, make missing keys explicit, and use the returned values in a dispatch quote.

   14 marked steps

2. 2. Approximate match and banded ratesAll-Access Pass

   Apply an ordered lower-bound table with XLOOKUP approximate match, prove boundary behaviour, and combine a load band with an exact route rate.

   14 marked steps

3. 4. INDEX and MATCHAll-Access Pass

   Separate row location from value return, perform left and two-way lookups, and keep formulas tied to named columns when the table structure changes.

   14 marked steps

4. 5. XLOOKUP beyond the defaultAll-Access Pass

   Reverse lookup, return adjacent fields as a spill, select a return field dynamically, and control wildcard and last-to-first search behaviour.

   14 marked steps

Finished Formulas? Sit the Formulas exam for its certificate.