Hello,

you need to adjust the row in the Index/Match by the row offset for that person. For example in D11 and copied down

=INDEX(Table9,MATCH($D$7,INDEX(Table9,0,1),0)+1+MATCH($D$6,INDEX(Table9,0,2),0)-2,MATCH($C11,INDEX(Table9,1,0),0))

cheers,