Variation of the lookup function

It's not clear (to me) if the [ ] are meant to represent cells or whether in fact:

[HD_CLOSE ] [ 7-14-2009 10:19:54 AM] [SomeGuy] [More text]

is a single string...

Could you post an sample file (via paperclip icon - click Go Advanced if not visible) - with the file illustrating what you have and what you want to return ?

Assuming you want to do this with formulae the attached would be one route - assumes range on source sheet may alter etc (ie volume of data not always the same)

The attached utilises named ranges (to minimise data processed) and a single column of helpers to reduce the calculation burden.

(also assumes no changes can be made to "Original" sheet)

The named range (_Data) should adapt itself dynamically - you simply need to copy the formulae used to generate the output enough times so as to ensure all records are being returned (as determined by the value in S8 in the sample file)

Presumably you can apply similar logic to before only now concentrate on those rows within Column 3 of _DATA that contain C, no ?
(Rather than Column 1 which contained HD_CLOSE as was the case in the prior request)

see attached as proof of concept (ie how you can modify)

the only difference from this to the first file is that know you specify

a) the criteria string (eg HD_CLOSE or C) in T6
b) the column in which that string will be found in your main table in T7 (1 for A, 2 for B etc...)

To get different results simply change the values in the yellow cells as appropriate, eg change T6 to C and T7 to 1 to get different results.
(if you want different results simultaneously copy the sheet and have different values in each)