Enter formula in B9 and copy down

=INDEX($B$2:$G$4,MATCH(A9,$A$2:$A$4,0),MATCH("Period "&B$6,$B$1:$G$1,0))