The XLOOKUP workflow that works
Keep the supplier list and your catalog in one workbook. Add a helper column beside your price, and match on stable supplier SKU with a fallback for misses:
=XLOOKUP([@SKU], SupplierList[SKU], SupplierList[Price], "NO MATCH")
Apply it down the column, filter out the misses, and review every remaining line before transferring values to the real price column. Start from a clean layout like the supplier price list template, and the broader comparison logic is covered in how to compare two supplier price lists in Excel. For stable SKUs, fixed packs, and one careful owner, this is enough. Respect it.
Three ways it breaks
First, the filtered paste bug. Copying helper values straight into the price column of a filtered view writes into hidden rows as well, silently repricing products outside the update. Link cells with a formula or enter values row by row, then paste as values only after verifying the row count matches.
Second, unit and pack blindness. XLOOKUP returns numbers, not meaning. A per-hundred quote lands beside a per-each cost, a box of 25 compares itself against a box of 10, and the sheet reports whatever the cells say. Catching that needs a reviewer checking the basis on both sides, which no formula does by itself.
Third, no memory and no margin.Formulas do not remember last quarter's matches, show nobody what changed or who approved it, and say nothing about margin impact. At a few thousand rows, or with two people editing, the workbook becomes a rumor. That is the point where the job stops being computation and starts being review.
Five signs you have outgrown formulas
Any two of these mean the workbook is now load-bearing infrastructure without any of the safety properties. That is the moment to move the review, not the formulas:
- The file passes 2,000 rows and takes minutes to recalculate.
- Two or more people edit it, and nobody knows who approved what.
- A supplier changed packs or units this year and the sheet never noticed.
- You keep a second shadow spreadsheet because you no longer trust the first.
- Month-end pricing questions take longer than the update itself.
What a reviewed workflow adds
A reviewed workflow keeps the parts of XLOOKUP that work and adds the parts it cannot do: SKU matching with mappings saved per supplier so the second file resolves faster, per-each normalization across every pack and unit change, margin context on each line, an explicit approve, correct, or reject decision with history, and an export containing only what was approved. Formulas compute. Reviews decide.
Try it on one file
The cheapest test is a side by side: run your next supplier file through the XLOOKUP workflow and through the free RowTune sample, then compare review time and caught errors. If the reviewed path wins, a $19 single-file pass runs one real spreadsheet through the full workflow with no subscription.
Frequently asked questions
What is the correct XLOOKUP formula for matching supplier prices?
With your catalog SKUs in an Excel table and the supplier list in the same workbook, a helper column with =XLOOKUP([@SKU], SupplierList[SKU], SupplierList[Price], "NO MATCH") pulls each new price alongside the old one. Filter out the misses, review the rest, and never paste values into a filtered view.
Why do prices go wrong when pasting into filtered Excel views?
A direct paste writes into hidden rows too, overwriting prices for products outside the update. Either enter values row by row or link cells with a formula such as =[@[New Price]], which only touches visible rows, then paste as values after verifying.
When is XLOOKUP no longer enough?
When pack sizes or units move, when multipliers change without list prices, when the file passes a few thousand rows, or when more than one person touches it. Each of those turns a formula task into a review task with decisions, history, and accountability.
What does a reviewed workflow add over formulas?
SKU matching with saved mappings, per-each normalization across packs and units, margin context per change, an explicit approve or reject on every line, and an export containing only approvals. Formulas compute. Reviews decide.