Index Match for three values

[AExcel]

Hi folks, I have been facing a problem with doing Index match for three variables at any given time. I have tried making a key of them but doesn't work.
Would be great if any one can help me out. Also my apologies if similar thing has already been answered on other thread.
Kindly find the file attached for the problem.

Thanks in Advance,
A.

 

[John Jairo V]

Hi, @AExcel

There are many ways to do it. Three of them:

Option 1:
=INDEX(B5:Q13,MATCH(A15,A5:A13,),MATCH(B15,B3:Q3)+MATCH(C15,B4:E4)-1)

Option 2:
=VLOOKUP(A15,A5:Q13,MATCH(B15,B3:Q3)+MATCH(C15,B4:E4),)

Option 3:
=VLOOKUP(A15,A5:Q13,1+4*(B15-1991)+RIGHT(C15),)

Blessings!

 

[AExcel]

Thanks a lot @John Jairo V for the super fast reply. Sorted my doubt on such kind of questions.

Happy Holidays