Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Working with array equations | Excel Discussion (Misc queries) | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Keeping Array values? | Excel Worksheet Functions |