look up from two seperate criteria across two sheets

[help excel]

Hi

Im trying to pull one piece of data from two criteria in excel , i need to use the surname and date to pull through the time can anybody help?

 

[JamesCanale]

MrExcelPlayground17.xlsx
	A	B	C	D	E	F	G
1	First Name	Last Name	Date	thing	thing	thing	Time
2	Bob	Smith	1/1/2022	a	b	c	0:45:23
3	Bob	Smith	2/1/2022	a	b	c	5:46:08
4	Bob	Smith	3/1/2022	a	b	c	5:49:51
5	Bob	Smith	4/1/2022	a	b	c	5:49:49
6	Bob	Smith	5/1/2022	a	b	c	5:45:47
7
8
9	Lookup
10	Last Name	Date	Time
11	Smith	3/1/2022	5:49:51
Sheet19

Cell Formulas
Range	Formula
C11	C11	=XLOOKUP(A11&B11,B2:B6&C2:C6,G2:G6,"",0)

 

[help excel]

Thankyou