Where is the bug in my array?
I've created an array of grade values:
{"A+","A","A-","B+","B","B-","C+","C","C-","D+","D","D-","F";4.3,4,3.7,3.3,
3,2.7,2.3,2,1.7,1.3,1,0.7,0.5}
The problem is that when use LOOKUP to look for "C-", I get 2.7 (which is
the value for B-) when I should get 1.7. (I.e., LOOKUP("C-", Array) returns
2.7, where Array is the array above.)
Here is the same array, formatted in rows (all I did was copy and paste it
into Notepad and add spaces):
{"A+","A","A-","B+","B","B-","C+","C","C-","D+","D","D-","F";
4.3, 4, 3.7, 3.3, 3, 2.7, 2.3, 2, 1.7, 1.3, 1, 0.7, 0.5}
Can anyone see what is causing this error?
Thanks in advance!
|