Finding data prior to a certain date

[yanyanyan]

[TABLE="width: 500"]
<tbody>[TR]
[TD]4/06/14 Logan Hyperdome-Michael Hill-Hi-5 Lo-Boy-2183
12/06/14 Logan Hyperdome-Michael Hill-Hi-5 Lo-Boy-2183
18/06/14 Logan Hyperdome-Michael Hill-Hi-5 Lo-Boy-2183
25/06/14 Logan Hyperdome-Michael Hill-Hi-5 Lo-Boy-2183
30/06/14 Logan Hyperdome-Michael Hill-Chuggington Lo-Boy-4876
9/07/14 Logan Hyperdome-Michael Hill-Chuggington Lo-Boy-4876
15/07/14 Logan Hyperdome-Michael Hill-Chuggington Lo-Boy-4876
22/07/14 Logan Hyperdome-Michael Hill-Chuggington Lo-Boy-4876
30/07/14 Logan Hyperdome-Michael Hill-Chuggington Lo-Boy-4876
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sorry I don't know how to paste a proper data, I wonder if there is a way to find out this data, I want to know in a large data, i want to find out the name that's prior to "Logan Hyperdome-Michael Hill-Chuggington Lo-Boy-4876" in this case will be "Logan Hyperdome-Michael Hill-Hi-5 Lo-Boy-2183" how to find this out? Thank you!

 

[steve the fish]

Is '30/06/14 Logan Hyperdome-Michael Hill-Chuggington Lo-Boy-4876' in one cell?

 

[yanyanyan]

No, separate cell, thanks

 

[yanyanyan]

Is '30/06/14 Logan Hyperdome-Michael Hill-Chuggington Lo-Boy-4876' in one cell?

separate cell, so basically i want to find the last details prior to my criteria which is Logan Hyperdome-Michael Hill-Chuggington Lo-Boy-4876

 

[steve the fish]

You need to be clearer. How many cells? Which parts are separate?

 

[yanyanyan]

You need to be clearer. How many cells? Which parts are separate?

Date are in column A, and the rest of the details in column B, thanks

 

[steve the fish]

With your search term in D1 try this formula in E1 (adjust the ranges to suit your data):

=INDEX($B$1:$B$1000,MATCH(D1,$B$1:$B$1000,0)-1)

 

[yanyanyan]

With your search term in D1 try this formula in E1 (adjust the ranges to suit your data):

=INDEX($B$1:$B$1000,MATCH(D1,$B$1:$B$1000,0)-1)

Omg thank you so much, it works!