Index/Match or sumproduct with concatenate

Hi,

Can anyone with help with a formula please? I have in the past used sumproduct however I need to know if it is possible to concatenate the data first?

On the attached file I have two sheets “Summary for slides” and “Sales by Product”. The sales by product sheet can not change or else I would have added a column and concatenated the data here.

Its there any way in which I can pull the data from the sales by product sheet where it would look up cell F4 on the “summary for slides” sheet and then match it with columns E and G on the “Sales by product” sheet and return the answer in column P

Any suggestions?

Paul