BenjieLop Wrote:
You can do this ...
In Columns A and B, you can enter the following:
Cell A1 : 21 Cell B1: 3a
Cell A2 : 26 Cell B2: 3b
Cell A3: 31 Cell B3: 3c
.
.
.
Cell A100: 95 Cell B100: 3z
NOTE: In Column A, the lower limit of the test score is what you will
enter.
And, in (say, Cell D1), you can enter this formula
=VLOOKUP(C1,$A$1:$B$100,2)
where Cell C1 will contain the child's test score.
Hope this will help you.
Regards.
Let's assume the children's names are in A1:A30. Their scores are in
B1:B30. Please give me precise instructions from here on.
Thanks in anticipation.
--
alexander_geoff
------------------------------------------------------------------------
alexander_geoff's Profile:
http://www.excelforum.com/member.php...o&userid=29822
View this thread:
http://www.excelforum.com/showthread...hreadid=495258