Index and Match on another Sheet

[Theluckyg]

What I would like to do is on sheet 4-6-2015 (I've got a sheet for every week of the year), look up the shift each employee is on for that week and display that in the B "Shift" column. I am using H1 as the Date reference.

so for B5 on sheet "4-6-2015" I've got
=INDEX(shiftstrings15!$B:$NH, MATCH($A5, shiftstrings15!$A:$A,0), Match($H1, INDEX(shiftstrings15!$B:$NH,1,0),0))

and it doesn't seem to output anything

 

[vllgv]

Does it give you #N/A or 0 or a blank cell? I am using your formula and pulling in the value On shiftstrings15 at the intersection of 4/6 and Johnson.