Return date and time of last entry made by each person

[Tashat]

Hello All

Thank you for the help I've received on here so far. Absolutely awesome forum. I'm using Excel 365.

I have two tables below

Table 1: Contact details
Table 2: Order details

In column D (highlighted green), I want to lookup from Table 2, what the most recent (last entry, by date and time) that each person made into the order table and show that time in column D alongside their name.

So for example in cell D2 for Joe Bloggs, it would automatically return "03/10/2020 19:15:25" as the date and time of Joe's last entry. I'd be very grateful for the support.

Name	Email	Tel	Latest Entry Date/Tim		Date/Time	Name	Data 1	Data 2	Data 3
Joe Bloggs	Joebloggs@whatever.com	1234			01/10/2020 15:42:23	Joe Bloggs	Happy	12	yes
Amy Gee	Amy Gee@whatever.com	15312			02/10/2020 10:22:03	Amy Gee	Happy	45	yes
Helen Water	Helen Water@whatever.com	1523132			02/10/2020 10:31:14	Helen Water	Excited	1	No
Sam Franks	Sam Franks@whatever.com	1531			02/10/2020 10:48:54	Sam Franks	Miserable	564	No
Richard Osgood	Richard Osgood@whatever.com	15345			02/10/2020 11:02:13	David Smith	Angry	43	yes
Tom Pond	Tom Pond@whatever.com	86451			02/10/2020 11:12:16	Richard Osgood	Anxious	54	No
Charlie New	Charlie New@whatever.com	15876			02/10/2020 14:41:23	Lexi Tracy	Happy	74	No
					02/10/2020 17:36:25	Charlie New	Miserable	23	No
					03/10/2020 17:57:18	Tom Pond	Happy	75	No
					03/10/2020 19:12:52	Charlie New	Anxious	1	yes
					03/10/2020 19:15:25	Joe Bloggs	Happy	7	No
					03/10/2020 22:09:52	Amy Gee	Happy	4	No
					03/10/2020 22:18:01	Amy Gee	Happy	43	yes
					03/10/2020 22:49:00	Naomi Chillcott	Miserable	1	No
					04/10/2020 08:00:41	Helen Water	Happy	74	yes
					04/10/2020 08:01:25	Sam Franks	Anxious	36	No
					04/10/2020 11:36:17	Richard Osgood	Happy	4	yes
					04/10/2020 12:17:57	Tom Pond	Happy	643	yes
					04/10/2020 12:52:59	Charlie New	Miserable	24	No
					04/10/2020 13:08:12	Lexi Tracy	Happy	1	yes

 

[Fluff]

If table 2 is always sorted on date/time, how about

=XLOOKUP(A2,$G$2:$G$21,$F$2:$F$21,"",0,-1)