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.
Last edited by papah73; 01-12-2012 at 06:20 AM.
Change the formula in C, D & E of your Student Record sheet to this -=VLOOKUP($B$3,INDIRECT("'"&$B$2&"'!$A$6:$E$11"),3)
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks