Match multiple criteria with a date that falls on a date range

[Newbie987654321]

Hi Guys. I so badly need your help.
Here's what I wanted to do.
I wanted to know if the following names from Table 1 have already submitted the documents considering that they submitted it after the Actual Date with the same infraction.
Table 2 shows the documents submitted.
I need a formula that would show if it has been "Submitted" or still "Pending" under the STATUS Column.
Those formulas that may need Ctrl+Shift+Enter, I need to get rid of that because I have multiple rows to drag it to.

Table 1
STATUS	Name	Supervisor	Infraction	Actual Date
Submitted	John Smith	April Allens	Tardiness	18-Mar-18
Pending	John Smith	April Allens	Tardiness	23-Mar-18
Submitted	Carl Lee	April Allens	Tardiness	18-Mar-18
Pending	Carl Lee	April Allens	Tardiness	23-Mar-18
Table 2
Name	Supervisor	Frequency	Date Submitted	Infraction
John Smith	April Allens	1st instance	21-Mar-18	Tardiness
Carl Lee	Sue Pervisor	1st instance	8-Mar-18	Tardiness
John Smith	April Allens	1st instance	21-Mar-18	Absence
Carl Lee	Sue Pervisor	1st instance	8-Mar-18	Absence

<tbody>
</tbody>