Index and match, matching with one more item (Item A and B)

Dear brothers and sister,

I have a weekly annoying task in the office. Every week, I printed the system report (use pivot table) and type data into corresponding cell manually. I believe it is quite time consuming.

I attached the workbook and appreciate if you can give the suggestion.
I have a table which contain branch, district, employee name column.
I only need to refer the value of specific account manager's products-(long term mutual fund others) sales value and (Long term mutual fund MIP) volumne.

I tried to use index and match function, however, it has limit on one matching criteria. How can I fix it? I searched in the forum, may be vlookup can help. However, I don't want to use Vlookup because it has limit that matching column should be ascending in alphatic.

Task:

As there is Long term mutual fund with MIP, Column C of "summary" is equal to Sheet"table" column K plus M
As there is Long term mutual fund with other, Column B of "summar" is equal to Sheet"table" column L plus N

Thanks everyone.
John