XLOOKUP, Finding a Value based on Time and Date

[juken1]

Hello
I'm looking for a formula I can fill down column I with

The formula I need should find a value in the C column, by matching the F and D column but after the Time (G column) and on the same date (H column)

The result should I2 should be 0.265
and I3 0.55

MergedStockData_05_07_2024_144528.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Number1	Time	Value1	Name	Date	Name	Time	Date	Value1
2	20240108	10:00:00 AM	0.27	TEST	Monday, 08 Jan 2024	TEST	10:16 AM	Monday, 8 January 2024	0.265	< Need Formula here.Example Result
3	20240108	10:15:00 AM	0.275	TEST	Monday, 08 Jan 2024	TEST2	1:33 PM	Saturday, 06 Apr 2024	0.55	< Need Formula here.Example Result
4	20240108	10:30:00 AM	0.265	TEST	Monday, 08 Jan 2024
5	20240108	10:45:00 AM	0.265	TEST	Monday, 08 Jan 2024
6	20240109	11:00:00 AM	0.265	TEST	Tuesday, 09 Jan 2024
7	20240109	11:15:00 AM	0.265	TEST	Tuesday, 09 Jan 2024
8	20240109	11:30:00 AM	0.265	TEST	Tuesday, 09 Jan 2024
9	20240109	11:45:00 AM	0.27	TEST	Tuesday, 09 Jan 2024
10	2024037	12:00:00 PM	0.27	TEST2	Saturday, 06 Apr 2024
11	2024037	12:15:00 PM	0.27	TEST2	Saturday, 06 Apr 2024
12	2024037	12:30:00 PM	0.27	TEST2	Saturday, 06 Apr 2024
13	2024037	12:45:00 PM	0.265	TEST2	Saturday, 06 Apr 2024
14	2024037	1:00:00 PM	0.265	TEST2	Saturday, 06 Apr 2024
15	2024037	1:15:00 PM	0.265	TEST2	Saturday, 06 Apr 2024
16	2024037	1:30:00 PM	0.265	TEST2	Saturday, 06 Apr 2024
17	2024037	1:45:00 PM	0.55	TEST2	Saturday, 06 Apr 2024
18	2024037	2:00:00 PM	0.265	TEST2	Saturday, 06 Apr 2024
Simulator

 

[SunnyAlv]

like this ?

=LET(
timetrigger,G2,datetrigger,H2,nametrigger,F2,
names,$D$2:$D$18,times,$B$2:$B$18,value,$C$2:$C$18,dates,$E$2:$E$18,
data,FILTER(HSTACK(times,value),(dates=datetrigger)*(names=nametrigger)),
XLOOKUP(timetrigger,CHOOSECOLS(data,1),CHOOSECOLS(data,2),"Not Found",1))