Finding an item based on nearest time

[Free3dom]

Hi guys, I have been trying to find the nearest next corresponding time in and an item sold at that time.

E. G.

Sheet 1 sheet 2
Time: Time: Item:
12:40:41 12:41:24 cheese
12:41:44 12:44:00 dogfood
12:44:05 12:44:10 milk


So from the above, I want to find out after each time in sheet 1, what item was sold from sheet 2 at the next corresponding time.

I have been stuck on this for weeks.... Please help
X

 

[svendiamond]

Can you give an example of what sheet 2 looks like and what exactly you want to return in which cell?

 

[Free3dom]

Sheet 2 has two columns:

Times: item:
12:41:24 cheese
12:44:00 dogfood
12:44:10 milk

 

[svendiamond]

Can you give an example of what your expected results would be? Are you just trying to find the item that corresponds with the closest match greater than the lookup time in column A? Or closest match less than the lookup time? (e.g. should 12:41:44 return "cheese" or "dogfood"?) The more details you can provide with your question the easier and faster you will get an answer.

 

[Free3dom]

Hi sorry,
So basically in sheet 1 there will be times in that format..... In sheet 2 there is different times with items processed at that time. I want to find the item that corresponds with the next closest et time from sheet 2 (using the time from sheet 1).

However in the list from sheet 2 there could be multiple items with the same time. In that case I would like all of the items sold at that time to be listed.

I hope that cleared it up....lol and not just confused things

Thx