Data Beginner

Explain a formula you inherited

You need a lookup that returns the most recent price for a product from a price-history table, but only for the customer's own price band.

Subscribers. The full prompt is part of the SMEMinds AI Playbook. See plans.

Before you use the output

Human review required. AI output is a confident first draft, not a verified answer.

Test the three rows before dragging down. Specifically test one Cancelled order and confirm it is excluded.
Check that column A contains real dates, not text. The edge-case note flags this as returning 0 silently — the worst kind of failure.
Verify the total against a manual sum of a small customer. Two minutes, and it catches a wrong column reference immediately.
If the sheet has other Status values you did not mention — 'Returned', 'Partially delivered' — decide explicitly how they should be treated.