I have created a progress card in Excel (there are 50 such sheets, one each for 50 students). There is one tabulation sheet also with the names of the 50 students. So, when numeric marks are entered into the tabulation sheet, it automatically converts them to letter grades, which are posted in the individual progress cards, so as a teacher I don't have to make 50 separate progress cards. Now the the problem is I am using the VLOOKUP
function, and it's working absolutely fine. But I have to paste it manually into 50 sheets and manually change the sheet number. Is there a different way of doing it?
I'm showing the formula I'm using so it will give a clear picture.
=IF(VLOOKUP(Sheet3!$I$13,'D:\result 2014-15\shcool results\[connect.xlsx]Sheet2'!$B$5:$BL$58,12,FALSE)>27,"A1",
IF(VLOOKUP(Sheet3!$I$13,'D:\result 2014-15\shcool results\[connect.xlsx]Sheet2'!$B$5:$BL$58,12,FALSE)>25,"A2",
IF(VLOOKUP(Sheet3!$I$13,'D:\result 2014-15\shcool results\[connect.xlsx]Sheet2'!$B$5:$BL$58,12,FALSE)>22,"B1",
IF(VLOOKUP(Sheet3!$I$13,'D:\result 2014-15\shcool results\[connect.xlsx]Sheet2'!$B$5:$BL$58,12,FALSE)>19,"B2",
IF(VLOOKUP(Sheet3!$I$13,'D:\result 2014-15\shcool results\[connect.xlsx]Sheet2'!$B$5:$BL$58,12,FALSE)>16,"C1",
IF(VLOOKUP(Sheet3!$I$13,'D:\result 2014-15\shcool results\[connect.xlsx]Sheet2'!$B$5:$BL$58,12,FALSE)>13,"C2","D")
)))))