Spreadsheet: 38658d1236796832-return-multiple-rows-in-an-array-with-the-same-value-lookup
Sheet: Day 1 Data Entry Form

SchoolID | School Name | Teacher | Grade | Group | # of Students per group | Grade lookup | Group Lookup | SchoolID Lookup
1 | MacKenzie | Mrs.[NAME] | 2 | A | 15 | 2 | A | 1
2 | MacKenzie | Mrs.[NAME] | 2 | B | 12 | 3 | B | 2
3 | Gladys | Mr. [NAME] | 3 | A | 16 | 4 | C | 3
4 | Gladys | Mr. [NAME] | 3 | A | 17 | 5 | D | 4
5 | Gladys | Mr. [NAME] | 4 | B | 12 |  | E | 5
6 | MacKenzie | Mrs.[NAME] | 5 | A | 15 |  | F | 6
7 | Hawthorne | Mr. [NAME] | 4 | A | 15 |  | G | 7
8 | Hawthorne | Mr. [NAME] | 4 | B | 15 |  | H | 8
9 | Hawthorne | Mr. [NAME] | 4 | C | 15 |  | I | 9
10 | Hawthorne | Mr. [NAME] | 4 | D | 15 |  | J | 10
11 | St. Matthew's | Mrs. [NAME] | 2 | A | 12 |  | K | 11
12 | St. Matthew's | Mrs. [NAME] | 2 | B | 13 |  | L | 12
13 | St. Matthew's | Mrs. [NAME] | 2 | C | 12 |  | M | 13
14 | St. Matthew's | Mrs. [NAME] | 2 | D | 12 |  | N | 14
15 | MacKenzie | Mrs. [NAME] | 3 | A | 15 |  | O | 15
16 | MacKenzie | Mrs. [NAME] | 3 | B | 15 |  | P | 16
17 | [NAME] | Mrs. [NAME] | 3 | A | 12 |  | Q | 17
18 | [NAME] | Mrs. [NAME] | 3 | B | 15 |  | R | 18
19 | [NAME] | Mr. [NAME] | 5 | A | 15 |  | S | 19
20 | [NAME] | Mr. [NAME] | 5 | B | 16 |  | T | 20
21 | [NAME] | Mr. [NAME] | 5 | C | 15 |  | U | 21
22 | [NAME] | Mrs. [NAME] | 5 | A | 15 |  | V | 22
23 | [NAME] | Mrs. [NAME] | 5 | B | 13 |  | W | 23
24 | [NAME] | Mrs. [NAME] | 4 | A | 15 |  | X | 24
 |  |  |  |  |  |  | Y | 25
 |  |  |  |  |  |  | Z | 26
 |  |  |  |  |  |  | AA | 27
 |  |  |  |  |  |  | AB | 28
 |  |  |  |  |  |  | AC | 29
 |  |  |  |  |  |  | AD | 30
 |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  | 84
 |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  | 87
 |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  | 89
 |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  | 91
 |  |  |  |  |  |  |  | 92
 |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  | 97
 |  |  |  |  |  |  |  | 98
 |  |  |  |  |  |  |  | 99
 |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  | 101
 |  |  |  |  |  |  |  | 102
 |  |  |  |  |  |  |  | 103
 |  |  |  |  |  |  |  | 104
 |  |  |  |  |  |  |  | 105
 |  |  |  |  |  |  |  | 106
 |  |  |  |  |  |  |  | 107
 |  |  |  |  |  |  |  | 108
 |  |  |  |  |  |  |  | 109
 |  |  |  |  |  |  |  | 110
 |  |  |  |  |  |  |  | 111
 |  |  |  |  |  |  |  | 112
 |  |  |  |  |  |  |  | 113
 |  |  |  |  |  |  |  | 114
 |  |  |  |  |  |  |  | 115
 |  |  |  |  |  |  |  | 116
 |  |  |  |  |  |  |  | 117
 |  |  |  |  |  |  |  | 118
 |  |  |  |  |  |  |  | 119
 |  |  |  |  |  |  |  | 120