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:

[TABLE="class: cms_table"]
<tbody>[TR]
[TD]A-Order#
[/TD]
[TD="width: 150"]B-Date Time[/TD]
[TD="width: 64"]C- EMP#[/TD]
[TD="width: 64"]D- Cust#[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]111[/TD]
[TD="class: cms_table_xl68"]12/28/2016 14:23[/TD]
[TD="class: cms_table_xl66"]Ann[/TD]
[TD="class: cms_table_xl66"]Jones[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]599[/TD]
[TD="class: cms_table_xl68"]12/28/2016 14:30[/TD]
[TD="class: cms_table_xl66"]Ann[/TD]
[TD="class: cms_table_xl66"]Jones[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]553[/TD]
[TD="class: cms_table_xl68"]12/29/2016 9:10[/TD]
[TD="class: cms_table_xl66"]bob[/TD]
[TD="class: cms_table_xl66"]smith[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]632[/TD]
[TD="class: cms_table_xl68"]12/29/2016 9:18[/TD]
[TD="class: cms_table_xl66"]bob[/TD]
[TD="class: cms_table_xl66"]Davis[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl69"]222[/TD]
[TD="class: cms_table_xl68"]12/29/2016 10:19[/TD]
[TD="class: cms_table_xl65"]jo[/TD]
[TD="class: cms_table_xl65"]Wills[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl69"]489[/TD]
[TD="class: cms_table_xl68"]12/29/2016 10:25[/TD]
[TD="class: cms_table_xl65"]jo[/TD]
[TD="class: cms_table_xl65"]Wills[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]158[/TD]
[TD="class: cms_table_xl68"]12/29/2016 9:18[/TD]
[TD="class: cms_table_xl67"]ken[/TD]
[TD="class: cms_table_xl67"]Adams[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]237[/TD]
[TD="class: cms_table_xl68"]12/29/2016 9:02[/TD]
[TD="class: cms_table_xl67"]ken Adams
[/TD]
[/TR]
</tbody>[/TABLE]


________________________________________________

[TABLE="class: cms_table, width: 516"]
<tbody>[TR]
[TD]Result: Orders 111 & 599 meet all 3 criteria[/TD]
[/TR]
[TR]
[TD]Result: Orders 222 & 489 meet all 3 criteria[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Ken's are orders have matching Customer names, but TIME is >>10Minutes[/TD]
[/TR]
[TR]
[TD]Bob's are orders have qualifying time but customer does not match
[/TD]
[/TR]
</tbody>[/TABLE]


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