You have more lookup values than return values.

LOOKUP uses the next highest value if it cannot find a match, so you don't need
as many values as you have.

Decide where the cutoff for any range will be then enter those in your formula.

=LOOKUP(L12,{0,49,50,53,56,59,63,66,67,69,73,76,79 },{"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"})

To test your values and lookups, enter the scores 48 to 79 in L15 down.

Enter your formula in M15 and drag/copy down.

See if the letter grades returned are what you want for each range of score.


Gord



On Wed, 6 Dec 2006 09:23:09 -0800, Andmor
wrote:

Gord, I posted this reply in my other post which is now 3 pages away...
wasn't sure if you'd see it so here it is again.

I am using your lookup formula as my base but I don't understand why i'm
getting an error. Here is my formula.

=LOOKUP(L15,{0,49,50,53,54,56,57,59,60,63,64,66,6 7,69,70,73,74,76,77,79},{"F","D-",”D”,”D+”,"C-","C","C+",”B-“,"B","B+",”A-“,”A”,"A+"})

Gord Dibben MS Excel MVP