Multiple Index Match in one cell

[OCDTeacher]

I am trying to have a cell check for a student's name in another tab (which could be in multiple locations on the other tab), then pull their attendance to the cell. I have successfully used Index Match to check one section of the document, but I need it to check for the student under each teacher's name.

INDEX('9.11.17'!C$3:C26,(MATCH($A5,'9.11.17'!$B$3:$B$27,0)))

I need to add to this to check column G on 9.11.17 and reference their attendance in column H (then check L, reference M, then check Q, reference R).

This is a link to an example document that I am working in.
https://docs.google.com/a/students....lSNNiLo696UXsKwvlDPJrgRhvotk/edit?usp=sharing

Any help would be greatly appreciated.

OCDTeacher

 

[James006]

Hello,

If you need to 'merge' all these checks into a single cell ... you might consider either :

1. Create a helper column in each of your daily attendance sheets ... and recup this data ...
or
2. Go ahead with a single array formula to build your complete matrix of results ...

HTH

 

[mart37]

Spreadsheet Formulas

Cell Formula C10 {=IFERROR(INDEX('9.11.17'!$A$1:$V$6,SUMPRODUCT(($A4='9.11.17'!$A$1:$V$6)*ROW($1:$6)),SUMPRODUCT(($A4='9.11.17'!$A$1:$V$6)*(TRANSPOSE(ROW($1:$22))))+1),"")} <tbody> </tbody>

Formula Array: Produce enclosing { } by entering formula with CTRL+SHIFT+ENTER!

<tbody>
</tbody>

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this a Google Sheets question or an Excel question? While we don't actually prohibit GS questions here, you need to understand that this is an Excel forum so that is what helpers here are expecting. So you should make it abundantly clear if the question is not an Excel one.

 

[OCDTeacher]

Ahh! Thank you so much!

 

[OCDTeacher]

I put the information in GS to have a link to share. I am a visual person, so I thought it would help!

 

[Peter_SSs]

I put the information in GS to have a link to share. I am a visual person, so I thought it would help!

Fair enough, but your sheet specifically says "WHAT WE WANT GOOGLE SHEETS FORMULA TO DO"