How to use XLOOKUP() to find commission benchmarks in Excel

Learn how to use both Excel’s XLOOKUP() and VLOOKUP() functions to find results between conditional benchmarks in Microsoft Excel.

Image: Wachiwit/Shutterstock

It’s common to track progress by means of benchmarks. Commissions on sales are a good example of this type of setup. Specifically, the commission percentage increases with the purchase total. For instance, if the total is between $1 and $299, the commission is 3%; if the total is between $300 and $499, the commission is 4%, and so on. In this article, I’ll show you how to use both XLOOKUP() and VLOOKUP() in Microsoft Excel to return the appropriate commission based on the total purchase price. It sounds more difficult than it really is. In this case, neither function proves superior to the other.

SEE: 83 Excel tips every user should master (TechRepublic)


Keep reading the full content on the TechRepublic site.

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Comment