VLOOKUP with an approximate match

Premium

In E2, find the commission rate for the sales in D2. The table lists where each band starts, so use VLOOKUP with TRUE for an approximate match.

E2
ABCDEF
1Sales from Rate Sales Rate
20 0.02 18000
310000 0.03
425000 0.05
550000 0.07
6
7
8

Premium lesson

Unlock VLOOKUP and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:INDEX and MATCHXLOOKUP

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?