Hi Somali,

If you need vlookup solution, you can use below one for year:-

=VLOOKUP($A$18,$A$1:$C$14,2,0)

and below one for value:-

=VLOOKUP($A$18,$A$1:$C$14,3,0)

Note:- If you have multiple results to be obtained... vlookup will pick up the upper one.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>