SUMIFS +vlookup and Month/Quarter to date

[Giancar]

Hi,

I have 2 tables in 2 sheets.

Sheet1

name	Margin MTD	Target MTD	Margin QTD	Target QTD
James
Mark
Frank
Jim
Russell
Conrad
Denis

<tbody>
</tbody>

Sheet2

Year	Quarter	Month	Day	Name	Margin	Target
2018	Q2	May	01-05-2018	James	10	20
2018	Q2	May	01-05-2018	Mark	20	20
2018	Q2	May	01-05-2018	Frank	25	15
2018	Q2	May	01-05-2018	Jim	31	30
2018	Q2	May	02-05-2018	James	23	22
2018	Q2	May	02-05-2018	Mark	4	18
2018	Q2	May	02-05-2018	Frank	100	66
2018	Q2	May	02-05-2018	Jim	32	41
2018	Q2	May	02-05-2018	Russell	11	40
2018	Q2	May	02-05-2018	Conrad	23	20
2018	Q2	May	03-05-2018	Mark		67
2018	Q2	May	03-05-2018	Denis		33
2018	Q2	June	05-06-2018	Mark		20
2018	Q2	June	05-06-2018	Frank		10
2018	Q2	June	05-06-2018	Jim		4
2018	Q2	June	05-06-2018	James		3

<tbody>
</tbody>

Result:
In B2 (Table Sheet1), I would like to have: sum column F (Table sheet2), <= Today date (dynamic), if column E (Table sheet2) is matching column A (Table sheet1) and it is the current month.
In C2 (table Sheet1), same per above, but sum of column G (Table sheet2)
In D2 (Table Sheet1), I would like to have: sum column F (Table sheet2), <= Today date (dynamic), if column E (Table sheet2) is matching column A (Table sheet1) and it is the current quarter or Q2.
In E2 (table Sheet1), same per above, but sum of column G (Table sheet2)

I tried to use helper column/cell but I am not able to find a solution by myself. Any help?

Thank you

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1054139-sumifs-vlookup-month-quarter-date.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).