Spreadsheet: 328798d1404092126-choose-function-not-returning-expected-results-choose-test-file
Sheet: Roll Sheets

Morning Session |  | Classroom 1 AM
Employee/Teacher: |  | Monday | Tuesday | Wednesday | Thursday | Friday |  | I am trying to get the roll taker names from the [NAME] sheet.
Number of students in room: |  |  |  |  |  |  |  | But the only name I get is Taker 1. How do I get the search to go horizontal?
Student | Grade
 |  |  |  |  |  |  |  | This is what I did to get the names from sheet [NAME]; look in A5.
 |  |  |  |  |  |  |  | What I want is to be able to get the names from sheet [NAME] starting in cell A2.
Morning Session |  | Classroom 1 AM
Employee/Teacher: |  | Monday | Tuesday | Wednesday | Thursday | Friday
Number of students in room: |  |  |  |  |  |  |  | How do I get the roll takers from sheet Room2A?
Student | Grade
 | 9 |  |  |  |  |  |  | How do I get the names from sheet Room2A?
 | 10
 | 10
 | 10
 | 10
 | 9
 | 10
 | 10
 | 10
 | 9
 | 10
 | 9
 | 10
 | 10
 | 10
 | 9
 | 10
 | 11
 | 11
 | 10
 | 10
 | 10
 | 10
Teacher Signature:
Morning Session |  | Classroom 3 AM
Employee/Teacher: | Grade |  | Number of students in the classroom:
 | 10 | Roll Taker | Roll Taker | Roll Taker | Roll Taker | Roll Taker
Student | 12
[NAME], [NAME] | 10
Calles, [NAME] | 12
Cornier-Rodriguez, Eddymar | 12
Deaton, Jaden | 10
[NAME], [NAME] | 10
Fiscal, Juan | 11
[NAME], [NAME] | 10
McGowan, Jake | 11
Ngwakwe, [NAME] | 12
Ojeda, Adrian | 11
Phillips, [NAME] | 11
Pridgett, Shena | 11
Rojas, [NAME] | 11
[NAME], [NAME] | 11
[NAME], George | 12
Villatoro, [NAME]
Wendt, [NAME]
Teacher Signature: | Roll Taker
Morning Session |  | Classroom 4 AM
Employee/Teacher: | Grade |  | Number of students in the classroom:
 | 12 | Roll Taker | Roll Taker | Roll Taker | Roll Taker | Roll Taker
Student | 10
[NAME], [NAME] | 12
Jones, [NAME] | 12
Loftin, [NAME] | 11
Martin, [NAME] | 10
Medina, [NAME] | 12
Molina, [NAME] | 12
Moreno, Lilia | 12
Sundberg, [NAME] | 10
Washburn, Jordyn
Wickline, Cassidy
Teacher Signature: | Roll Taker
Morning Session |  | Classroom 10 AM
Employee/Teacher: | Grade |  | Number of students in the classroom:
 | 11 | Roll Taker | Roll Taker | Roll Taker | Roll Taker | Roll Taker
Student
Smith, [NAME]
Teacher Signature: | Roll Taker
Afternoon Session |  | Classroom 1 Mid
Employee/Teacher: | Grade |  | Number of students in the classroom:
 | 9 | Roll Taker | Roll Taker | Roll Taker | Roll Taker | Roll Taker
Student | 9
Barclay, Alexis | 9
Gutierrez, [NAME] | 9
[NAME], [NAME] | 9
Smith, [NAME] | 9
[NAME], [NAME]
Youngs, [NAME]
Teacher Signature: | Roll Taker
Afternoon Session |  | Classroom 2 Mid
Employee/Teacher: | Grade |  | Number of students in the classroom:
 | 10 | Roll Taker | Roll Taker | Roll Taker | Roll Taker | Roll Taker
Student | 10 | 2014-05-26 00:00:00
[NAME], [NAME] | 9
Bergin, [NAME] | 9
Cano, [NAME] | 10
Cooper, Amanda | 9
Gillespey, Lesley | 10
Green, Lindsey | 10
[NAME], Alanis | 10
[NAME], Maria | 10
Moore, Maison | 9
Morris, [NAME] | 10
Norris, Cory | 11
Pazos, Cesar | 9
Ramos, [NAME] | 10
Reed, Daysia | 10
Selim, Karim | 10
Sexton, [NAME] | 9
Shlesinger, Emily | 10
Soto, Alejandro | 10
Studer, Carlisle
Swaim, [NAME]
Teacher Signature: | Roll Taker
Afternoon Session |  | Classroom 3 Mid
Employee/Teacher: | Grade |  | Number of students in the classroom:
 | 11 | Roll Taker | Roll Taker | Roll Taker | Roll Taker | Roll Taker
Student | 11
Bergman, Robyn | 11
Blount, [NAME] | 11
Gearhart, Peyton | 11
[NAME], [NAME] | 12
Harper, [NAME] | 11
Haugen, [NAME] | 11
Hungrige, Klara | 11
Martinez, [NAME] | 11
Navarro, Jaqueline | 10
Ogbebor, Uwadia | 10
Patrick, Asa | 11
Villareal, [NAME]
Wagner, [NAME]
Teacher Signature: | Roll Taker
Afternoon Session |  | Classroom 4 Mid
Employee/Teacher: | Grade |  | Number of students in the classroom:
 | 11 | Roll Taker | Roll Taker | Roll Taker | Roll Taker | Roll Taker
Student | 12
Commons, Adam | 11
Haworth, Angelica | 12
Perez, Cristian
Thornock, [NAME]
Teacher Signature: | Roll Taker
Afternoon Session |  | Classroom 10 Mid
Employee/Teacher: | Grade |  | Number of students in the classroom:
 | 11 | Roll Taker | Roll Taker | Roll Taker | Roll Taker | Roll Taker
Student
Smith, [NAME]
Teacher Signature: | Roll Taker
Afternoon Session |  | Classroom 11
Employee/Teacher: | Grade |  | Number of students in the classroom:
 |  | Roll Taker | Roll Taker | Roll Taker | Roll Taker | Roll Taker
Student
Teacher Signature: