alexander_geoff Wrote:
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.
With the children's names in A1:A30 and their corresponding test scores
in B1:B30,a no-frills solution is as follows:
1. *Construct a table * (say, use Columns G and H) and enter the
following:
Cell G1=21 and Cell H1=3c
Cell G2=26 and Cell H2=3b
Cell G3=31 and Cell H3=3a
2. In Cell C1, enter the following formula
=VLOOKUP(B1,$G$1:$H$3,2)
3. Copy this formula down until C30. To copy a formula all the way down
to C30, do the following:
*** point your mouse to the right bottom corner of Cell C1
*** as soon as you see a "black crosshair" (*+*), left click on the
mouse and drag it down to Cell C30
*** release the mouse as soon as you are in Cell C30
Hope this is what you are looking for.
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=495258