I am sorry I never received an e-mail from you so I did not think you responded to my question yet - once I closed this window I did not see any response from you until I reopened this original question.
I will try and explain as best I can:
The formulas need to be in workbook '1314 GN Fitness Data Test' sheet 'Cumulative' and the 1st cell will be 'P4'. The formula needs to 1st check what grade the student is in (9,10,11,12) then use the VLOOKUP statement to access the proper Data Workbook based on that grade level and pull the data that is in the same corresponding sheet 'Cumulative' and cell 'P4'.
The only Data Workbook I sent you was for grade 12 therefore you may want to start with cell 'P11', however the 1st piece of data for that student is in cell 'T9'.
So basically the formula needs to do the following: from the 1st workbook (1314 GN Fitness Data Test) check (IF) to see what grade the student is in (9,10,11,12) then use the student ID to lookup his scores in the appropriate Data Workbook (GN_14_FD) within the same named sheet (Cumulative) and the same corresponding cell.
I then need to duplicate this formula for all columns P through BC.
Let me know if this helps. Hopefully you can get this done somewhat soon as I need this formula in order to proceed with my project.
Like I said I never received an e-mail like I have always in the past so I never checked to see that you responded to me.