Excel price lookup for date and product name

This article describes several alternative approaches to solving a lookup problem in Excel.

Specifically, the problem is: given an on-going list of invoices, create a lookup formula to find the product price based on the invoice date.

Also have a look at the article's comments, where readers propose additional solutions.