Shivani Gupta
New Member
Hello, I am a teacher, I give remarks to my students based on their scores. I have defined ranges of scores as 0-10, 11-20, 21-30 and so on. If for example, the student scores between 0 to 10 marks, say 9 marks, the remark "Perforrmance is poor" is displayed and so on.
I used the Lookup formula: =LOOKUP(B12,{0,10,11,15,16,20,21,30},{"Perforrmance is poor","Perforrmance is poor","Performance is not up to the mark","Performance is not up to the mark",Performance is simply average","Performance is simply average","Performance is fairly good","Performance is fairly good"}). This is working fine. I have copied this formula to all the sheets. But I have 50 students and 50 different sheets for them. I want to store the remarks in a different worksheet and the remarks should be returned from that sheet instead of specifying them in the formula. So that if I have to change a remark, I dont have to do it in every sheet. Please let me know how I can do this.
I used the Lookup formula: =LOOKUP(B12,{0,10,11,15,16,20,21,30},{"Perforrmance is poor","Perforrmance is poor","Performance is not up to the mark","Performance is not up to the mark",Performance is simply average","Performance is simply average","Performance is fairly good","Performance is fairly good"}). This is working fine. I have copied this formula to all the sheets. But I have 50 students and 50 different sheets for them. I want to store the remarks in a different worksheet and the remarks should be returned from that sheet instead of specifying them in the formula. So that if I have to change a remark, I dont have to do it in every sheet. Please let me know how I can do this.