I'm a teacher and my class have done a test. I've got some analysis of their performance in each question. I want to lookup the largest value in column B (best question) and return the question number (Column A) for that.
That works fine.
I then try the same but to find the worst question and I get the repsonse #N/A. I don't quite understand why.
The data are as follows:
A B
1 Q Score
2 1 1.13
3 2 1.13
4 3 -0.94
5 4 -1.29
6 5 -1.34
7 6 -0.67
8 7 0.11
9 8 0.91
10 9a -0.88
11 9b -1
12 10ab 0.93
13 10c -1.21
14 11 -1
15 12 0.88
16 13 -0.83
17 14 0.94
18 15 -0.88
19 16 -0.13
20 17 0.72
21 18 -0.85
22 19 0.2
23 20 -1.32
24 21 1.19
25 22 -0.06
26 23 1.15
27 24 -0.48
28 25 0.31
29 26 1.15
30 27 0.5
31 28 1.41
The query =LOOKUP(MAX(B2:B31),B2:B31,A2:A31)
returns 28, as it should, but the query =LOOKUP(MIN(B2:B31),B2:B31,A2:A31)
returns #N/A
.
Any advice?