Array formula: return data from adjacent column?

[suppersong]

Hi,

Simple question, I hope. I'm using an array formula to return search results from $D$1 to column F (see below). The array formula is:
=INDEX($B$1:$B$5000,SMALL(IF(ISNUMBER(SEARCH($D$1, $B$1:$B$5000)),ROW($B$1:$B$5000)-ROW($B$1)+1),E2))

How do I get the formula to return the corresponding dates from column C to column G?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=INDEX($C$1:$C$5000,AGGREGATE(15,6,(ROW($B$1:$B$5000)-ROW($B$1)+1)/(ISNUMBER(SEARCH($D$1, $B$1:$B$5000))),ROWS(G$2:G2)))

You could also use

=INDEX($B$1:$B$5000,AGGREGATE(15,6,(ROW($B$1:$B$5000)-ROW($B$1)+1)/(ISNUMBER(SEARCH($D$1, $B$1:$B$5000))),ROWS(F$2:F2)))

both of these are "normal" formulae & don't need array entry

 

[suppersong]

Thank you! for both those suggestions. Exactly what I needed. I was having trouble getting the AGGREGATE function to work. I don't know why, but your code did the trick.

 

[Fluff]

You're welcome & thanks for the feedback.