Calculate Sales Commission in Excel Using XLOOKUP

Calculating sales commission accurately is essential for sales tracking and performance analysis. In this tutorial, you’ll learn how to calculate sales commission in Excel using the powerful XLOOKUP function by connecting two tables efficiently.

## 🧮 Understanding the Tables

You’ll typically work with two Excel tables:

• Sales Table – Contains sales values or employee names.
• Commission Rate Table – Stores commission percentages for each category.

::contentReference[oaicite:0]{index=0} ## 🔗 Connecting Tables Using XLOOKUP

To pull the commission rate from the second table into the sales table, use the XLOOKUP formula.

Example formula structure:

=XLOOKUP(B2, Sheet2!B1:B5, Sheet2!C1:C5, -1)

### Explanation:

• B2 – Lookup value from the sales table
• B1:B5 – Lookup range in the commission table
• C1:C5 – Return range containing commission rates
• -1 – Default value if no match is found

Once the formula is entered, simply drag it down to apply the commission rate calculation to all rows.

## ✅ Final Output

Excel instantly calculates the commission for each sales entry by matching the correct rate. This method eliminates manual errors and makes your reports scalable and professional.

## 📌 Key Benefits

• Faster commission calculations
• Error-free data matching
• Easy to update commission rates
• Ideal for sales dashboards and reports