Hi all,

I have a column of cells that I want to VLookup the answer for. It's
for a snooker tournament. It could be for a golf tournament too!

I have a sheet (GRADES) with three columns. A2 to B8 contain values
that I want compared. In C2:C8 are the results of the comparison.

It's a rolling handicap down from A2 to A8, B2 to B8, and C2 to C8.
These are the values :

-30 -10 A
-9 0 B
1 10 C
11 20 D
21 30 E


If a player's handicap is -17 (between -30 and -10, (A2 and B2)), then
his grade is 'A' (C2)

I just cannot figure how to do the VLookup to display C2 in the other
sheet...

thanks in anticipation

Pete