Lookup Column value when 2 Row values Match

[TechInTeaching]

Requesting formula assistance for following: If 2 cells in Column D Match & Column C Match & Column B 'Date Time' is < 10 Minutes Result is corresponding value from Column A.

To answer the question "What orders were done by same employee from the same Customer during the same Order call?"
Data:

A-Order#	B-Date Time	C- EMP#	D- Cust#
111	12/28/2016 14:23	Ann	Jones
599	12/28/2016 14:30	Ann	Jones
553	12/29/2016 9:10	bob	smith
632	12/29/2016 9:18	bob	Davis
222	12/29/2016 10:19	jo	Wills
489	12/29/2016 10:25	jo	Wills
158	12/29/2016 9:18	ken	Adams
237	12/29/2016 9:02	ken Adams

<tbody>
</tbody>

________________________________________________

Result: Orders 111 & 599 meet all 3 criteria

Result: Orders 222 & 489 meet all 3 criteria

Ken's are orders have matching Customer names, but TIME is >>10Minutes

Bob's are orders have qualifying time but customer does not match

<tbody>
</tbody>

Assistance is greatly appreciated for data set used exceeds 5K each time period

TechInTeaching

 

[snjpverma]

Tech you seem to have interchanged the Less than and greater than symbols

 

[TechInTeaching]

Ken's example is FALSE...same customer Adams BUT the time interval is GREATER THAN the 10 minutes [16 minutes]... looking for TRUE statements