I have a spreadsheet that has up to 200 facilities and each facility will be listed up to 6 times. The sheet has current month and the last date of the previous month. I need to do a look up to pull the previous months total to be on the current months row.

Example
Month Current Previous
1/31/2012 $100
2/29/2012 $500 $100

Can this be done if so how