Returning Value from Time Ranges

[Mooboos]

Hi Everyone
I have a data table that shows a list of times Trailers were tipped, from which site in time order such as
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Despatch Site[/TD]
[TD]Time of Trailer Unloaded[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28/02/2016[/TD]
[TD]MD01[/TD]
[TD]06:13[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28/02/2016[/TD]
[TD]KA09[/TD]
[TD]06:56[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28/02/2016[/TD]
[TD]MD19[/TD]
[TD]07:42[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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
[TABLE="width: 500"]
<tbody>[TR]
[TD]06:20[/TD]
[/TR]
[TR]
[TD]06:31[/TD]
[/TR]
[TR]
[TD]07:50[/TD]
[/TR]
</tbody>[/TABLE]

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]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Date[/TD]
[TD]Despatch Site[/TD]
[TD]Time of Trailer Unloaded[/TD]
[TD]Sheet1[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]28/02/2016[/TD]
[TD]MD01[/TD]
[TD]

6:13​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]28/02/2016[/TD]
[TD]KA09[/TD]
[TD]

6:56​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]28/02/2016[/TD]
[TD]MD19[/TD]
[TD]

7:42​

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]




[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

6:20​

[/TD]
[TD]MD01[/TD]
[TD]sheet2[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

6:31​

[/TD]
[TD]MD01[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

7:50​

[/TD]
[TD]MD19[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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

 

[Mooboos]

Hi thank you

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

Thanks

 

[MARZIOTULLIO]

HI

Odd that it doesn't work for you. It works on my end.