Need to populate select cells onto another page if date stamp falls in a time range.

[joplrw10]

I have seen a few samples of this, but I can't seem to be able to get it to work correctly for me.

I have a set that looks

DateSample Data 1 Data 2 Data 3

I am populating into a set that would look like this

Date 1 Data 1 Data 2 Data 3 Data 4
Date 2 Data 1 Data 2 Data 3 Data 4
Date 3 Data 1 Data 2 Data 3 Data 4
Date 4 Data 1 Data 2 Data 3 Data 4
Date 5 Data 1 Data 2 Data 3 Data 4
Date 6 Data 1 Data 2 Data 3 Data 4
Date 7 Data 1 Data 2 Data 3 Data 4
Date 8 Data 1 Data 2 Data 3 Data 4

I need the functionality that if DateSample is between Date 2 and Date, I would be able to populate the cells in that row with the data from the DateSample line. Not necessarily in the order that they are in. Data 3 for DateSample might go to the Data 2 spot in the sheet.

I am sure there is a simple way to do this, but I am not finding it at the moment.

Thank you.

Rj

[knitterkuba]

What happens if the date falls between Date 2 and Date 8 but there is no row with data in it? If your dates will match the dates in the first column then you should be able to do a vlookup. Does the order of the Data matter to you at all or can they be in any order (like the same order they were in)?

[joplrw10]

My dates will almost never be exactly the same. The dates in the data set that is being populated to is constantly changing and updating based on =NOW() so the dates are changing. The data that is being pulled into the table is being arranged chronologically.

Right now, I have a data set that is spaced 1 hour apart and pulls live data.

If the date/time for that set falls between 1200 and 1300, and I have a Sample1 that falls at 1309, I need the set to populate Data1 from Sample1 into a the row that is designated for between 1200 or 1300.

Does that make sense?

[joplrw10]

Capture.JPG

Here is a better explanation.

Here is a picture of what I need. I need the values from Table 2 to populate into the corresponding cells in Table 1.

[knitterkuba]

Here is a solution that might work for you but you will need to add two extra columns. Assuming that "Data1" is in C2, add two columns after column E.
F3: =INT(E3) (This gives you just the date)
G3: =HOUR(E3-(INT(E3))) (This gives you just the hour)
C3: =INDEX(F3:H9,MATCH(1, (F3:F9=INT(B3))*(G3:G9=HOUR(B3-INT(B3))),0),3)

When you plug in C3, make sure you press CTRL+SHIFT+ENTER instead of just pressing enter. This is not a graceful solution but it is a solution. Hope you find this useful

[joplrw10]

Figured it out using sumproduct. Worked beautifully.