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...