Multiple lookup with with variable dates, convert to fixed series of dates

I have a database which has a date, item code, and price. I need to look at the price for any single item during the past twelve months. There are many months in which the price is not changed, so I can't use a simple pair of sumproducts (or at least I haven't figured out how to do that). I'm grateful for any ideas! I have attached a sample.