More info:
As mentioned, the VLOOKUP formula(s) in question on the "Summary" sheet refer to cells on the "Data" sheet. When a value is entered in the cells of the "data" sheet the value does not appear in the cells of the "Summary" sheet. Could this have something to do with any of the following settings:
Automatic vs Manual Calculation
Update Remote References
Save External link Values