Spreadsheet: 99649d1298264160-search-multiple-columns-and-rows-and-return-row-list
Sheet: Sheet1

CLASS | NAME | PHONE NUMBER | [NAME] | Option | Designation | Extracurricular | SEARCH: | (THIS IS WHERE TO SEARCH I1)
4/C | A1 | [PHONE] | [EMAIL] | Navy Option | A1 | Regulation Drill |  |  | This is where the Results would go.
1/C | A2 | [PHONE] | [EMAIL] | Navy Option | Staff |  |  |  | Then down, but I would like the full row returned when searching for something.
3/C | A3 | [PHONE] | [EMAIL] | Navy Option | A1
OC | A4 | [PHONE] | [EMAIL] | OC | A2 |  |  |  | Example: You type in Soccer in the search box, and for a result you get:
4/C | A5 | [PHONE] | [EMAIL] | Navy Option | A1 | Regulation Drill
3/C | A6 | [PHONE] | [EMAIL] | Navy Option | B2 |  |  |  | 4/C | A3 | [PHONE] | [EMAIL] | Navy Option | A1 | Soccer
OC | A7 | [PHONE] | [EMAIL] | OC | Staff |  |  |  | 3/C | A17 | [PHONE] | [EMAIL] | MECEP | Staff | Soccer, Exhibition Drill
OC | A8 | [PHONE] | [EMAIL] | OC | B1
3/C | A9 | [PHONE] | [EMAIL] | Nurse Option | B2
2/C | A10 | [PHONE] | [EMAIL] | Navy Option | A2 | Soccer
1/C | A11 | [PHONE] | [EMAIL] | Marine Option | Staff | Semper Fi Society, Bulldog
4/C | A12 | [PHONE] | [EMAIL] | Navy Option | B2 | Regulation Drill
4/C | A13 | [PHONE] | [EMAIL] | Navy Option | A2 | Regulation Drill
3/C | A14 | [PHONE] | [EMAIL] | Navy Option | A1
3/C | A15 | [PHONE] | [EMAIL] | Navy Option | Staff
1/C | A16 | [PHONE] | [EMAIL] | Navy Option | A1
4/C | A17 | [PHONE] | [EMAIL] | Navy Option | B1 | Regulation Drill
3/C | A18 | [PHONE] | [EMAIL] | Navy Option | B1
2/C | A19 | [PHONE] | [EMAIL] | Navy Option | Staff
3/C | A20 | [PHONE] | [EMAIL] | Navy Option | A2
OC | A21 | [PHONE] | [EMAIL] | OC | B2
2/C | A22 | [PHONE] | [EMAIL] | Navy Option | B2
1/C | A23 | [PHONE] | [EMAIL] | Navy Option | B1
Sgt 4/C | A24 | [PHONE] | [EMAIL] | MECEP | A2 | Semper Fi Society, Bulldog
2/C | A25 | [PHONE] | [EMAIL] | Marine Option | A2 | Semper Fi Society, Bulldog
3/C | A26 | [PHONE] | [EMAIL] | Navy Option | A1
2/C | A27 | [PHONE] | [EMAIL] | Navy Option | A1
2/C | A28 | [PHONE] | [EMAIL] | Navy Option | A2
1/C | A29 | [PHONE] | [EMAIL] | Navy Option | Staff
OC | A30 | [PHONE] | [EMAIL] | OC | B1
1/C | A31 | [PHONE] | [EMAIL] | Navy Option | A2
3/C | A32 | [PHONE] | [EMAIL] | Navy Option | A2
2/C | A33 | [PHONE] | [EMAIL] | Marine Option | B1 | Semper Fi Society, Bulldog
OC | A34 | [PHONE] | [EMAIL] | OC | A2
OC | [NAME] | [PHONE] | [EMAIL] | OC | A1
3/C | A36 | [PHONE] | [EMAIL] | Navy Option | B2
2/C | A37 | [PHONE] | [EMAIL] | Marine Option | Staff | Semper Fi Society, Bulldog, Exhibition Drill
2/C | A38 | [PHONE] | [EMAIL] | Navy Option | Staff
2/C | A39 | [PHONE] | [EMAIL] | Navy Option | B1
3/C | A40 | [PHONE] | [EMAIL] | Navy Option | B2
1/C | A41 | [PHONE] | [EMAIL] | Nurse Option | Staff
3/C | A42 | [PHONE] | [EMAIL] | Nurse Option | B1
2/C | A43 | [PHONE] | [EMAIL] | Navy Option | Staff
3/C | [NAME] | [PHONE] | [EMAIL] | Navy Option | A1
SSgt 1/C | A45 | [PHONE] | [EMAIL] | MECEP | A1 | Semper Fi Society, Bulldog
2/C | A46 | [PHONE] | [EMAIL] | Marine Option | B2 | Semper Fi Society, Bulldog
2/C | A47 | [PHONE] | [EMAIL] | Navy Option | Staff
4/C | A48 | [PHONE] | [EMAIL] | Navy Option | B1 | Regulation Drill
4/C | A49 | [PHONE] | [EMAIL] | Navy Option | B2 | Regulation Drill
2/C | [NAME] | [PHONE] | [EMAIL] | Marine Option | B2 | Semper Fi Society, Bulldog
2/C | A51 | [PHONE] | [EMAIL] | Navy Option | B2 | Soccer
OC | A52 | [PHONE] | [EMAIL] | OC, Nurse Option | B1
3/C | A53 | [PHONE] | [EMAIL] | Navy Option | A1
2/C | [NAME] | [PHONE] | [EMAIL] | Marine Option | Staff | Semper Fi Society, Bulldog, Soccer, Recruiting
3/C | A55 | [PHONE] | [EMAIL] | Navy Option | B1
Sgt | [NAME] | [PHONE] | [EMAIL] | MECEP | A1 | Semper Fi Society, Bulldog
2/C | A57 | [PHONE] | [EMAIL] | Marine Option | B2 | Semper Fi Society, Bulldog
OC | A58 | [PHONE] | [EMAIL] | OC | Staff
SSgt 4/C | A59 | [PHONE] | [EMAIL] | MECEP | A2 | Semper Fi Society, Bulldog
3/C | A60 | [PHONE] | [EMAIL] | Navy Option | A2
OC | A61 | [PHONE] | [EMAIL] | OC | A1
OC | A62 | [PHONE] | [EMAIL] | OC | Staff
2/C | A63 | [PHONE] | [EMAIL] | Marine Option | B1 | Semper Fi Society, Bulldog
OC | A64 | [PHONE] | [EMAIL] | OC | A1
3/C | A65 | [PHONE] | [EMAIL] | Nurse Option | A1
4/C | A66 | [PHONE] | [EMAIL] | Navy Option | A2 | Regulation Drill
OC | A67 | [PHONE] | [EMAIL] | OC | B2
2/C | A68 | [PHONE] | [EMAIL] | Navy Option | A1
Sgt | A69 | [PHONE] | [EMAIL] | MECEP | B2 | Semper Fi Society, Bulldog
3/C | A70 | [PHONE] | [EMAIL] | Marine Option | Staff | Semper Fi Society, Bulldog
2/C | [NAME] | [PHONE] | [EMAIL] | Navy Option | B2
3/C | A72 | [PHONE] | [EMAIL] | Marine Option | B1 | Semper Fi Society, Bulldog
4/C | A73 | [PHONE] | [EMAIL] | Navy Option | A1 | Regulation Drill
4/C | A74 | [PHONE] | [EMAIL] | Navy Option | B1 | Regulation Drill
4/C | A75 | [PHONE] | [EMAIL] | Navy Option | B2 | Regulation Drill
2/C | A76 | [PHONE] | [EMAIL] | Navy Option | A2 | Soccer
Sgt | A77 | [PHONE] | [EMAIL] | MECEP | B1 | Semper Fi Society, Bulldog
2/C | A78 | [PHONE] | [EMAIL] | Navy Option | B1
3/C | A79 | [PHONE] | [EMAIL] | Marine Option | A2 | Semper Fi Society, Bulldog
4/C | A80 | [PHONE] | [EMAIL] | Navy Option | A1 | Regulation Drill
OC | A81 | [PHONE] | [EMAIL] | OC | B2
2/C | A82 | [PHONE] | [EMAIL] | Navy Option | A2
4/C | A83 | [PHONE] | [EMAIL] | Navy Option | A2 | Regulation Drill
4/C | A84 | [PHONE] | [EMAIL] | Navy Option | B1 | Regulation Drill
OC | A85 | [PHONE] | [EMAIL] | OC | B2
3/C | A86 | [PHONE] | [EMAIL] | Navy Option | B1
2/C | [NAME] | [PHONE] | [EMAIL] | Navy Option | B2
4/C | A88 | [PHONE] | [EMAIL] | Marine Option | A1 | Semper Fi Society, Bulldog, Regulation Drill
4/C | A89 | [PHONE] | [EMAIL] | Marine Option | A2 | Semper Fi Society, Bulldog, Regulation Drill
4/C | A90 | [PHONE] | [EMAIL] | Navy Option | A1 | Regulation Drill
Candidate | A91 | [PHONE] | [EMAIL] | Candidate | B1
1/C | A92 | [PHONE] | [EMAIL] | Navy Option | B1
4/C | A93 | [PHONE] | [EMAIL] | Marine Option | B2 | Semper Fi Society, Bulldog, Regulation Drill
3/C | A94 | [PHONE] | [EMAIL] | Nurse Option | B1
4/C | A95 | [PHONE] | [EMAIL] | Marine Option | A2 | Semper Fi Society, Bulldog, Regulation Drill
3/C | A96 | [PHONE] | [EMAIL] | Navy Option | B2
OC | A97 | [PHONE] | [EMAIL] | OC | B1
4/C | A98 | [PHONE] | [EMAIL] | Marine Option | B2 | Semper Fi Society, Bulldog, Regulation Drill
OC | A99 | [PHONE] | [EMAIL] | OC | A2
OC | A100 | [PHONE] | [EMAIL] | OC | A2
1/C | [NAME] | [PHONE] | [EMAIL] | Navy Option | A1
4/C | A102 | [PHONE] | [EMAIL] | Marine Option | A1 | Semper Fi Society, Bulldog, Regulation Drill
4/C | A103 | [PHONE] | [EMAIL] | Marine Option | B1 | Semper Fi Society, Bulldog, Regulation Drill