Good day all,

I have an issue and would appreciate your help.

I'm searching for the word HD_CLOSE and if found, I want excel to return the row where this word is found on another sheet.

Problem: the row to be returned contains a custom date format of type < 8-11-2009 9:21:11 AM >

When I use LOOKUP, I get an error for these date formats.

Here is a sample:
[HD_CLOSE ] [ 7-14-2009 10:19:54 AM] [SomeGuy] [More text]

Any ideas how to go around this? (and no I can't change the date format in the original tables)

Thanks;