Look up in ranges: prices, tiers, sizes

Shipping by weight or a bonus by sales: you don’t look for an exact value, you look for the band it falls into. VLOOKUP with TRUE, or XLOOKUP with a match mode, does exactly that.

5 exercises in this lesson are part of ExcelHero Pro.