Newbie987654321
New Member
- Joined
- Mar 13, 2018
- Messages
- 9
Hi Guys. I so badly need your help.
I want to know the STATUS of Table 1.
CRITERIA OF SUBMITTED STATUS:
-DATE (Table 2) > or equal to Actual Date (Table 1)
-Name, Supervisor and Infraction should match.
If no match, then it should be "PENDING".
I need a formula that would show if it has been "Submitted" or still "Pending" under the STATUS Column.
Here's an example table which shows the STATUS.
<tbody>
</tbody>
I want to know the STATUS of Table 1.
CRITERIA OF SUBMITTED STATUS:
-DATE (Table 2) > or equal to Actual Date (Table 1)
-Name, Supervisor and Infraction should match.
If no match, then it should be "PENDING".
I need a formula that would show if it has been "Submitted" or still "Pending" under the STATUS Column.
Here's an example table which shows the STATUS.
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>