Excel Price Lookup Date Product Name

If there’s just one price per product in an Excel lookup table, you could use the INDEX and MATCH functions to to get that price. But what if the price changes occasionally, and your pricing list has multiple dates and prices for each product? How can you do a product price lookup based on invoice date and product name?

All-In-One Formulas

Thanks to David P and Leonid K, who also sent formulas, and these didn’t require any changes to the pricing table. All three of their formulas are better than the one that I created – shorter and easier to read.