Lookup formula

[chytech]

Please sir / Madam,

I need urgent help with the below;

I have two tables. I want to be able to search for the ID from a lookup table and return the one that closely matches the date and time of the main table.

Please see sample tables below;

Main table

ID	Date time	Vlookup Value
1035	3/14/2021 20:51:56
1035	3/19/2021 18:30:54	3/19/2021 20:51:56
1090	3/14/2021 18:24:19
1090	3/14/2021 17:58:31

Vlookup Table

id	Vlookup Value
1035	3/19/2021 20:51:56

Please help thanks;

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Urgent Help with Excel lookup formula please
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[chytech]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Urgent Help with Excel lookup formula please
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

ok this is noted. Please can you help ?