INDEX MATCH Return multiple data for YTD calculation

[Chakra]

Greetings to all,

Now I have tackled this problem with the offset function, however I can not use it since I need to collect these data from different excel files in a different server. (I am getting a Value Error and need to have all these files opened)
My next solution would be to use the Index Match function, however I can't figure out how to receive multiple data.

Please find below the actual file:
https://drive.google.com/open?id=0B2h3XyxKdC6wU1VfZ0w5SURPTE5XVEhTdjN5aXRoR2Z6VGVN

If I wanted to receive one cell data, that would be easy by using the function below:
=INDEX(D9:O20;MATCH(C4;C9:C20;0);MATCH(C5;D8:O8;0))

I cant seem to receive multiple data and sum them for YTD calculation. So if the column_num variable would be for any date lesser than the date in C5, how would we go about this, since the correct answer would be d9+e9?
I thought maybe this however I do not get any answer:
=INDEX(D9:O20;MATCH(C4;C9:C20;0);MATCH("<="&C5;D8:O8;0))

The way I did it with the offset function was :
=SUM(OFFSET(C8,MATCH(C4,C9:C20,0),1,,MATCH(C5,D8:O8)))

Thank you for your time and effort

 

[bosco_yip]

Try this Index/Match function which will return the result as same your last Offset function.

In D6 :

=SUM(INDEX(D9:D20,MATCH(C4,C9:C20,0)):INDEX(D9:O20,MATCH(C4,C9:C20,0),MATCH(C5,D8:O8,0)))

Regards
Bosco

 

[Chakra]

You Sir are a savor!
My mind got stuck!

Thank you so much!