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>
Bookmarks