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,084,735
Messages
5,379,503
Members
401,608
Latest member
nanana2020

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top