View Single Post
  #1   Report Post  
Gail Gurman
 
Posts: n/a
Default 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!