Linking worksheets

[papah73]

I am a very raw user of excel and hope someone can help me with what is probably a simple problem. I would like to construct a 'Student Data' page where by typing in the year and the student ID you will get academic results from that year and the previous year. While I can set it up to run once I cannot get it to change when I change the year.

I have attached a trial sheet. It is the formulas on the "Student Record' Page I am have difficulties with. I want it so that if I change the year to 2012 the 'current' and 'previous year data will change.

[arlu1201]

Change the formula in C, D & E of your Student Record sheet to this -

Please Login or Register  to view this content.

[TMS]

C6: =IFERROR(VLOOKUP($B$3,INDIRECT("'"&$B$2&"'!$A$6:$E$11"),COLUMN(C6),FALSE),0)
C7: =IFERROR(VLOOKUP($B$3,INDIRECT("'"&$B$2-1&"'!$A$6:$E$11"),COLUMN(C6),FALSE),0)

Copy across


Regards, TMS