Lookup multiple entries in a column

[Rhemo]

I am looking for help to lookup exact and multiple entries on a column, then have the data from the same rows go to another sheet.

example:
Column A contains names.
Column B Contains unneeded data for copying
Column C contains dates
Column D contains products

so I would need to find, for example, all rows that contain John in Column A, then have the values in the cells of columns C and D's corresponding rows replicated to another sheet, omitting the data in column B.

I am hoping this can be done with formulas but all my searching so far seems to indicate that I cannot.

Many Thanks!

[Fotis1991]

Perhaps something like this? ARRAY formula..

=index(a$1:a$100;small(if($a$1:$a$100="John";row(a$1:a$100));row(a1)))

[Rhemo]

HAHA, I finally found a youtube video on it using a play on your formula.

Thank you for you help Fotis!

link to the YT vid: http://www.youtube.com/watch?v=Tp7I5u1MqiM

[Fotis1991]

.......................