Comparing 2 Tables and Pulling Row from 1 Into the Other If it Takes Place within 20 Minutes AFTER the original date/time stamp

[Legacy 367570]

Hi All,

Bit of a complicated one. Any help much appreciated!!!

So I have two sets of data I want to link together.


Both have time stamps in format mm/dd/yyyy hh:mm in each row.


I for each row in table 1, I want to look at the time stamp, then return the details of the row in table 2 that occurs within 20 minutes AFTER the date and time stamp in table 1. The formula should ONLY return the row with the highest value based on another column


So

Table 1

Name	Time	Output Data 1	Output Data 2	Output Data 3
John	02/02/2016 08:45:00	? <tbody> </tbody>	?	?
Luke <tbody> </tbody>	02/08/2016 06:00 <tbody> </tbody>	?	?	?
Sarah <tbody> </tbody>	02/15/2016 12:52 <tbody> </tbody>	?	?	?
Ben <tbody> </tbody>	02/20/2016 21:45 <tbody> </tbody>	?	?	?

<tbody>
</tbody>

Table 2

Product <tbody> </tbody>	Time <tbody> </tbody>	Value <tbody> </tbody>	Additional Value 1 <tbody> </tbody>	Additional Value 2 <tbody> </tbody>	Additional Value 3 <tbody> </tbody>
Apple <tbody> </tbody>	02/15/2016 08:55 <tbody> </tbody>	5.665 <tbody> </tbody>	a	6	r
Orange <tbody> </tbody>	02/20/2016 06:08 <tbody> </tbody>	3.874 <tbody> </tbody>	5	w	x
Pear <tbody> </tbody>	02/02/2016 12:58 <tbody> </tbody>	9.254 <tbody> </tbody>	7	5	3
Water <tbody> </tbody>	02/08/2016 22:02 <tbody> </tbody>	2.987 <tbody> </tbody>	1	!	=
Soda <tbody> </tbody>	02/08/2016 21:56 <tbody> </tbody>	1.157 <tbody> </tbody>	d	w	d
Coke <tbody> </tbody>	02/20/2016 06:18 <tbody> </tbody> ​	3.997 <tbody> </tbody>	1	2	3

<tbody>
</tbody>

Output

Name <tbody> </tbody>	Time	Product	Time	Value	Additional Value 1 <tbody> </tbody>	Additional Value 2 <tbody> </tbody>	Additional Value 3 <tbody> </tbody>
John	02/02/2016 08:45 <tbody> </tbody>	Apple <tbody> </tbody>	02/15/2016 08:55 <tbody> </tbody>	5.665 <tbody> </tbody>	a	6	r
Luke	02/08/2016 06:00 <tbody> </tbody>	Coke <tbody> </tbody>	02/20/2016 06:18 <tbody> </tbody>	3.997 <tbody> </tbody>	1	2	3
Sarah	02/15/2016 12:52 <tbody> </tbody>	Pear <tbody> </tbody>	02/02/2016 12:58 <tbody> </tbody>	9.254 <tbody> </tbody>	7	5	3
Ben	02/20/2016 21:45 <tbody> </tbody>	Water <tbody> </tbody>	02/08/2016 22:02 <tbody> </tbody>	2.987 <tbody> </tbody>	1	!	=

<tbody>
</tbody>

As you can see above, each of the returned rows are within 20 minutes after the original, and for Ben and Luke, return the rows with the highest value.


Any ideas on how I can achieve this?


Thanks in advance!