Lookup values in an array

I am sure there is a way to do this but my brain is slowly melting.

I have attached an example of what i would like to do.

I need to be able to select a year and then have Excel look across the array, find the correct column and then look up the nearest value to the mark and then return a grade.

I am sure there is a combination of INDEX and MATCH functions that would do it but as I say.... brain dying.

Please help.

Something like below.

=INDEX(G2:G8,MATCH(B14,INDEX(A2:F8,,MATCH(B13,A1:F1,0)),0))

When using an Array be sure to use the ctrl+Shift+enter to activate the array. If just using enter the array will sometimes return n/a