IntermediateSalesAbout 8 minutes

Sample data

Price list (fictional) Row 1 holds the headings. All data is fictional. Dates are year-month-day.

Steps

Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.

Find the price of P-103 with VLOOKUP. FALSE means an exact match.
Result15
Return the product name instead by changing the column number to 2.
ResultMonitor stand
See what a wrong code does.
Result#N/A "P-999" was not found in the first column.
Wrap it in IFERROR to show a message.
ResultCode not in price list
The modern way: XLOOKUP, which also works to the left.
ResultP-103
Classic alternative that works in every Excel: INDEX with MATCH.
Result32

Use VLOOKUP or XLOOKUP when you have a code and need a detail. Always ask for an exact match.

MatchFlowCompare purchase orders, invoices and goods received lists: missing items, extra items, quantity and price differences.

Looking for different features or something built around your workflow? Share your idea with us.