---
title: "Commission Payout Audit — VLOOKUP + IFERROR | SheetDo"
url: https://stacklist.com/card/1b8f46ad-e8eb-4b30-8edd-92e6c22cd308
source_url: "https://sheetdo.com/practice/commission-payout-audit/?utm_source=stacklist&utm_medium=directory&utm_campaign=excel-sales-rep-stack"
stack: https://stacklist.com/c/business/stack/c63a8f97-5e08-4630-8e71-f2794bad0e8b
summary: "Commission Payout Audit is a practice problem on SheetDo that teaches users to audit commission payouts by comparing computed commissions against paid amounts using VLOOKUP and IFERROR functions. The exercise requires entering a formula in cell G2 that computes the difference between calculated commission (bookings × rate) and actual payout, handling missing reps as zero values."
tags: "spreadsheet, vlookup, commission-audit, excel-formula, iferror, lookup-reference, practice-problem"
key_entities: "SheetDo (organization), VLOOKUP (technology), IFERROR (technology), SUMIF (technology), commission-payout-audit (concept), lookup-reference (concept)"
classification: "tutorial"
content_hash: "sha256:36fa222e408e907130ad4f308393e49496e4a81c32da7b353d35c6c6b4e93d9c"
acp_version: "0.2"
token_counts_approximate: 581
visibility: public
agent_accessible: true
status: "final"
---

# Commission Payout Audit — VLOOKUP + IFERROR | SheetDo

Practice problems / Lookup & Reference Audit a commission payout against two tables (VLOOKUP + IFERROR) Hard Lookup & Reference Sales pack SheetDo · Updated November 4, 2026 Description Hints 0/4 Solutions 0 – Test case 1 Reset Submit fx A B C D E F G 1 2 3 4 5 6 7 8 9 10 Loading interactive spreadsheet... Preparing grid cells and formula calculation engine ○ Ready Enter formula in highlighted cells, then click Submit. Description Hints 0/4 Solutions 0 – Test case 1 Reset Submit fx A B C D E F G 1 2 3 4 5 6 7 8 9 10 Loading interactive spreadsheet... Preparing grid cells and formula calculation engine ○ Ready Enter formula in highlighted cells, then click Submit. The problem Problem statement Booking and rate are in B2:C2 , so row 2's commission can be recomputed. What payroll actually paid is in the second table at E2:F4 , and some reps are missing from it. Put the difference (computed − paid) in the Difference cell G2 . A rep who is not in the payout table was paid nothing — that is a difference, not an error. Problem data Show the sheet as a table (selectable, copyable) Copy as TSV The exercise data, as a table A B C D E F G 1 Rep Bookings Rate Computed Rep Paid Difference 2 Ada 10000 0.05 Ada 500 3 Ben 20000 0.04 Ben 700 4 Cleo 5000 0.06 Zoe 300 Notes Two lookups in one formula: compute the commission from the first table, find the paid amount in the second, subtract. IFERROR covers the rep who never appears in the payout run; treating that as 0 turns a broken #N/A into the very finding the audit is looking for. How to approach Your answer goes in G2. Target cell is G2 Computed commission is B2*C2 Look the rep up in the payout table Shape: =?*?-IFERROR(?, 0) Function guide VLOOKUP · IFERROR · SUMIF Related practice Default to zero on missing discount (VLOOKUP + IFERROR) Handle missing SKUs in a lookup (IFERROR) Commission by attainment tier (approximate lookup) Commission from a tier table (approximate INDEX MATCH) All practice problems → FAQ How do I reconcile a commission payout? Recompute the commission (bookings × rate), look up what was paid, and subtract. A missing payer should read as 0, not #N/A. Why not VLOOKUP for the paid amount? It works when the payout table has one row per rep. If a rep can be paid twice, VLOOKUP returns only the first row; SUMIF adds them.