Data · Beginner · about 16 minutes

Formulas — describe what you want in English, get the formula, verify it

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. You know exactly what you want. You spend forty minutes on forums, assemble something from three answers, and it returns #N/A on 200 of 4,000 rows for reasons you cannot diagnose.

You need

Version: Excel 365. Sheet 'Orders', data from row 2, headers row 1.

Tool

Any assistant

You get

1. THE FORMULA =SUMIFS(F:F, B:B, G2, E:E, "Delivered", A:A, ">="&TODAY()-90) 2.

Time saved

A formula that would take 40 minutes of searching takes about 4, including verification.