G
Guest
I have an excel spreadsheet with the following:
a b c
1 NAME Race1 Race 2
2 Kaytee 00:41.00 02:33.10
3 Kristen 00:31.66 02:12.54
4 Lauren 02:13.54
5 Lauren R 00:31.44 02:26.75
6 Lauren S 00:43.18 02:34.90
7 Lisa 00:34.72 02:11.54
8 Lisa f
9 Liz 00:28.43 02:13.52
10
11 Min Value 00:28.43 02:11.54
12 Name #NA #NA
I want to return the name of the person in row 12 which matches the min
Value from row 11 for each of the races. When I use the following fomula I
get a error of NA: =LOOKUP(b11,B2:B11,A2:A11).
Any thoughts on what I am doing wrong or how to fix the problem would be
appreciated
Mark
a b c
1 NAME Race1 Race 2
2 Kaytee 00:41.00 02:33.10
3 Kristen 00:31.66 02:12.54
4 Lauren 02:13.54
5 Lauren R 00:31.44 02:26.75
6 Lauren S 00:43.18 02:34.90
7 Lisa 00:34.72 02:11.54
8 Lisa f
9 Liz 00:28.43 02:13.52
10
11 Min Value 00:28.43 02:11.54
12 Name #NA #NA
I want to return the name of the person in row 12 which matches the min
Value from row 11 for each of the races. When I use the following fomula I
get a error of NA: =LOOKUP(b11,B2:B11,A2:A11).
Any thoughts on what I am doing wrong or how to fix the problem would be
appreciated
Mark