Worked thanks
BenjieLop Wrote:
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.
--
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