In D9
=IFERROR(INDEX(A$2:A$7,MATCH($D$10,$A$2:$A$7,0)),INDEX(A$2:A$7,MATCH($D$10,$A$2:$A$7,1)))
In D11
=IFERROR(INDEX(A$2:A$7,MATCH($D$10,$A$2:$A$7,0)),INDEX(A$2:A$7,MATCH($D$10,$A$2:$A$7,1)+1))
In E9
=INDEX(B$2:B$7,MATCH($D9,$A$2:$A$7,0))
Copy down and across
Bookmarks