Retrieve nearest value and titles from sheet data

I need to retrieve nearest Value from Sheet to based on matching grades and then need to pull column titles of nearest values which are different as per value pulled.

query mentioned in attached file.
I have tried using Index, match, if and vlookup but not able to pull required result. help required.