Vlookup for time between

[Sajeer Ahammed]

Hi
There are two Data tables.I would like to pull the location from first table according to time in 2nd table.But the problem is that mentioned time in 2nd table is precise and it is in between start time and end time in first table..Please help..

Table 1

Location​	Start Time​	End Time​
Start​	04-11-2023, 08:01:23 AM​	04-11-2023, 08:38:25 AM​
Carrefour City Centre​	04-11-2023, 08:38:25 AM​	04-11-2023, 08:38:41 AM​
Carrefour City Centre​	04-11-2023, 08:38:41 AM​	04-11-2023, 08:42:38 AM​
Carrefour City Centre​	04-11-2023, 08:42:38 AM​	04-11-2023, 08:42:48 AM​
Carrefour City Centre​	04-11-2023, 08:42:48 AM​	04-11-2023, 09:18:20 AM​
MONOPRIX SHOP​	04-11-2023, 09:18:20 AM​	04-11-2023, 09:18:33 AM​
MONOPRIX SHOP​	04-11-2023, 09:18:33 AM​	04-11-2023, 09:34:57 AM​
carrefour,landmark​	04-11-2023, 09:34:57 AM​	04-11-2023, 10:43:29 AM​
carrefour,landmark​	04-11-2023, 10:43:29 AM​	04-11-2023, 10:43:40 AM​
carrefour,landmark​	04-11-2023, 10:43:40 AM​	04-11-2023, 10:44:21 AM​

Table 2

Time​	Desired Data​
04-11-2023, 08:50:07 AM​	Carrefour City Centre​
04-11-2023, 09:36:30 AM​	carrefour,landmark​

 

[p45cal]

See attached Power Query query at cell G1.
It took me quite a while to twig that there was a unicode character 8203 (aka PQ parlance #(200B)), a zero-width space, among your date strings which needed removing before converting to a proper date/time stamp would work. (See cell B14.)

 

[p45cal]

…and then I discover a cross post where this was solved hours ago: https://community.fabric.microsoft.com/t5/Desktop/Time-span/m-p/3515613
grrrr

 

[vletm]

Sajeer Ahammed​

As You've read from Forum Rules ... which is for You too:

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.