D

#### DubboPete

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