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