The lookup_vector *must* be sorted in ascending order. Try it like this:

=LOOKUP(F11,{"A","A-","A+","B","B-","B+","C","C-","C+","D","D-","D+","F"},{95,90,100,80,75,85,65,60,70,50,45,55, 40})

--
Biff
Microsoft Excel MVP


"Jerry" wrote in message
...
I have the following function
=LOOKUP(F11,{"A+","B+","C+","D+","A-","B-","C-","D-","A","B","C","D","F"},{100,85,70,55,90,75,60,45,9 5,80,65,50,40})
and when say cell F11 = A it returns #N/A even though the equivalent
should
be 90 or if F11 = B or B- returns 100, is there anything wrong with this
formula. Thanks in advance