Perhaps try also, in AF8 (normal ENTER):
=IF(AF6="","",IF(ISNA(MATCH(AF6,$J$8:$J$100,0)),IF (ISNA(MATCH(AF6,$T$8:$T$10
0,0)),"No date matches found",INDEX(TRIM($K$8:$K$100&"
"&$O$8:$O$100),MATCH(AF6,$T$8:$T$100,0))),INDEX(TR IM($K$8:$K$100&"
"&$O$8:$O$100),MATCH(AF6,$J$8:$J$100,0))))
Some assumptions:
---------------------------
Source range in cols J, K, O, T is within row 8 to row 100
Unique dates in cols J and T
Sequential checks: Col J is checked ahead of col T
Returns of text is required from both cols K and O, separated by a space
Any unmatched dates will return: "No date matches found"
Adapt to suit ..
A sample construct is at:
http://cjoint.com/?bFrwPxPItm
roy_okinawa_TextSearch_wks.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---