Returning Value from Time Ranges

Mooboos

New Member
Joined
Mar 9, 2016
Messages
8
Hi Everyone
I have a data table that shows a list of times Trailers were tipped, from which site in time order such as
DateDespatch SiteTime of Trailer Unloaded
28/02/2016MD0106:13
28/02/2016KA0906:56
28/02/2016MD1907:42

<tbody>
</tbody>


I then on a separate sheet have a list of data with times on which I need to return the value of the Despatch Site for that time.

So
06:20
06:31
07:50

<tbody>
</tbody>

Would return These despatch sites as they fall within the time period before the next Trailer
06:20 MD01
06:31 MD01
07:50 MD19

Does anyone know of a calculation for me to do this and not do it manually?

Thanks in advance
 

MARZIOTULLIO

Well-known Member
Joined
Aug 22, 2015
Messages
767
A
B
C
D
1
DateDespatch SiteTime of Trailer UnloadedSheet1
2
28/02/2016MD01
6:13​
3
28/02/2016KA09
6:56​
4
28/02/2016MD19
7:42​

<tbody>
</tbody>




A
B
C
1
6:20​
MD01sheet2
2
6:31​
MD01
3
7:50​
MD19

<tbody>
</tbody>


B1 =LOOKUP(Sheet2!A1,Sheet1!$C$2:$C$4,Sheet1!$B$2:$B$4) copy down
 

Mooboos

New Member
Joined
Mar 9, 2016
Messages
8
Hi thank you

It doesn't seem to be pulling back it just comes up with N/A?

Thanks
 

Forum statistics

Threads
1,085,566
Messages
5,384,476
Members
401,904
Latest member
markschneider89

Some videos you may like

This Week's Hot Topics

Top