VLOOKUP a date+time with only a date

[rgsanchez]

Can I Vlookup a date+time if I only have the time? For example, I have the Scheduled Time only in Table B. I want to Vlookup the Date+Time from Table A.

[TABLE="width: 740"]
<tbody>[TR]
[TD]Table A: Reference Table[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Table B: Final Table[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Scheduled Date+Time[/TD]
[TD]Actual+Time[/TD]
[TD][/TD]
[TD]Scheduled Time[/TD]
[TD]Actual Date+Time (VLOOKUP)[/TD]
[/TR]
[TR]
[TD="align: right"]8/1/2019 4:00[/TD]
[TD="align: right"]8/1/2019 4:00[/TD]
[TD][/TD]
[TD="align: right"]4:00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8/1/2019 4:06[/TD]
[TD="align: right"]8/1/2019 4:06[/TD]
[TD][/TD]
[TD="align: right"]4:06[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8/1/2019 4:07[/TD]
[TD="align: right"]8/1/2019 4:08[/TD]
[TD][/TD]
[TD="align: right"]4:07[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Sam_D_Ben]

I am not sure if this work for you. Please check.

Excel 2013/2016
	A	B	C	D	E
1	Scheduled Date+Time	Extr-Time	Actual+Time	Scheduled Time	Actual Date+Time (VLOOKUP)
2	8/1/19 4:00	04:00	8/1/19 4:00	4:00	8/1/19 4:00
3	8/1/19 4:06	04:06	8/1/19 4:06	4:06	8/1/19 4:06
4	8/1/19 4:07	04:07	8/1/19 4:08	4:07	8/1/19 4:07
Sheet1

Cell Formulas
Range	Formula
B2	=TEXT($A2-INT($A2),"HH:MM")
E2	=INDEX($A2:$A4,MATCH(TEXT($D2-INT($D2),"HH:MM"),$B2:$B4))