Max Look Up with Multiple Criteria

[darian]

I have a time sheet Table that I pull from Share point and it's linked. to fill the table I have 4 criteria that must be met .Any formula I use It gives me zero result and don't show me the actual Time in the time sheet. Can you help me?

Employee Name Sales Manager ClockType Date Time

Doe, Jane	Amber, Smith	Clock In	8/2/2016	1:2 PM
Doe, Jane	Amber, Smith	Lunch In	8/2/2016	1:3 PM
Doe, Jane	Amber, Smith	Clock Out	8/2/2016	1:22 PM

<tbody>
[TD="align: right"]8/2/16 13:02[/TD]

[TD="bgcolor: #DBE5F1"]Doe, Jane[/TD]
[TD="bgcolor: #DBE5F1"]Amber, Smith[/TD]
[TD="bgcolor: #DBE5F1"]Lunch Out[/TD]
[TD="bgcolor: #DBE5F1"]8/2/2016[/TD]
[TD="bgcolor: #DBE5F1"]1:2 PM[/TD]
[TD="bgcolor: #DBE5F1, align: right"]8/2/16 13:02[/TD]

[TD="align: right"]8/2/16 13:03[/TD]

[TD="bgcolor: #DBE5F1"]Doe, Jane[/TD]
[TD="bgcolor: #DBE5F1"]Amber, Smith[/TD]
[TD="bgcolor: #DBE5F1"]Clock Out[/TD]
[TD="bgcolor: #DBE5F1"]8/2/2016[/TD]
[TD="bgcolor: #DBE5F1"]1:3 PM[/TD]
[TD="bgcolor: #DBE5F1, align: right"]8/2/16 13:03[/TD]

[TD="align: right"] 8/2/16 13:22 [/TD]

[TD="bgcolor: #DBE5F1"]Doe, Jane[/TD]
[TD="bgcolor: #DBE5F1"]Amber, Smith[/TD]
[TD="bgcolor: #DBE5F1"]Clock In[/TD]
[TD="bgcolor: #DBE5F1"]8/3/2016[/TD]
[TD="bgcolor: #DBE5F1"]9:15 AM[/TD]
[TD="bgcolor: #DBE5F1, align: right"]8/3/16 9:15[/TD]

</tbody>

Now I need to fill my below table and I might need to use max because an employee may input their date twice :

	1) Employee:
	2) Sales Manager:
Doe, Jane
Doe, Jane
Doe, Jane

<tbody>
[TD="bgcolor: #FFFF00"]Doe, Jane[/TD]
[TD="colspan: 2, align: center"]Today's Date:[/TD]
[TD="align: center"]8/3/2016[/TD]

[TD="align: center"]Amber, Smith[/TD]
[TD="colspan: 2, align: center"]Week Startting:[/TD]
[TD="align: center"]8/1/2016[/TD]

[TD="bgcolor: #DBE5F1, colspan: 2"]Date[/TD]
[TD="bgcolor: #DBE5F1"]Employee[/TD]
[TD="bgcolor: #DBE5F1"] 4) Clock In[/TD]
[TD="bgcolor: #DBE5F1"]Lunch Out[/TD]
[TD="bgcolor: #DBE5F1"]Lunch In[/TD]
[TD="bgcolor: #DBE5F1"]Clock Out[/TD]
[TD="bgcolor: #DBE5F1"]Total Lunch[/TD]
[TD="bgcolor: #DBE5F1"]Unpaid Lunch[/TD]
[TD="bgcolor: #DBE5F1"]Total Paid Hrs[/TD]

[TD="bgcolor: #F2F2F2"]Monday[/TD]
[TD="bgcolor: #F2F2F2"] 3) 8/1/2016[/TD]

[TD="align: right"]0:00[/TD]
[TD="align: center"]#VALUE![/TD]

[TD="bgcolor: #F2F2F2"]Tuesday[/TD]
[TD="bgcolor: #F2F2F2"]8/2/2016[/TD]

[TD="align: right"]0:00[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0:00[/TD]
[TD="align: center"]#VALUE![/TD]

[TD="bgcolor: #F2F2F2"]Wednesday[/TD]
[TD="bgcolor: #F2F2F2"]8/3/2016[/TD]

[TD="align: right"]0:00[/TD]
[TD="align: center"]#VALUE![/TD]

[TD="bgcolor: #F2F2F2"]...[/TD]
[TD="bgcolor: #F2F2F2"]...[/TD]

[TD="align: right"][/TD]
[TD="align: center"][/TD]

[TD="bgcolor: #EEECE1"]Total Hours[/TD]
[TD="bgcolor: #EEECE1, align: center"]#VALUE![/TD]

</tbody>

 

[darian]

Figured it out. Thanks!