View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
alexander_geoff
 
Posts: n/a
Default Greater than, smaller than formula


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