index match for 3 lookup values

[krazyhype19]

Hi,

Here's my table:

2014 2014 2014 2013 2013 2013
Jan Feb Mar Jan Feb Mar
A 56 63 100 78 25 44
B 48 12 74 32 65 97
C 45 85 96 42 82 73

How will I use index match function to get the data that correspond to each criteria? For example I am looking for the value of A in Mar 2013.

Thank you!

[sktneer]

Find the attached sheet to see if this is what you are trying to achieve.

[krazyhype19]

Attached is my file. There were blank rows/cells and I cannot get the exact formula for this. I cannot change the format of the template as this is the original design and may affect other links.

Thanks!

[sktneer]

See the attached sheet.

[krazyhype19]

Thank you!

I need more help with this example:

I need to get the value for YTD. If my current month is May, then I need to add Q1 plus the value of April and May. Or Add the value of Jan-May.

Please...