With that layout you could use

In B8
=INDEX($4:$4,,MATCH("Year "&A8,$1:$1,0))
Note: Year 10 and Year 11 have a single space between year & no. of year while others have two. Get this amended

or if years are always chronological in both arrays
=INDEX($B$4:$U$4,A8)

Copy down