Excel 2007 : Lookup returning old values

You could try forcing a re-calculation when you workbook opens by inserting the following code into the ThisWorkbook tab in the VBA editor (Alt F11).

Private Sub Workbook_Open()
Calculate
End Sub