Excel Question - Fairly Basic

[Sheff]

Hi,

I'm a pretty much a novice user when it comes to functions and macros within Excel and have a problem:

I have a table that is pasted into Excel from a webpage, from this I then have a function that searches a string, looks up data from a table and displays the first match from that table.

What I would like is for the function to display all matches from the table rather than just the first.

So far I have this =LOOKUP(9.999999999E+307,SEARCH(Table1[Names],Sheet1!X1),Table1[Names])

Google helped me with the intial function, however I'm unable to find how to expand on this.

If possible I'd like to avoid Macros (to avoid having to tell people to change their security settings).

Edit: I though it best to provide an example,

Say I have a string; "personaDonald.Duck personbMicky Mouse"

and a table;
Micky.Mouse
Donald.Duck

I currently would only get "Micky.Mouse" returned, when I would like "Micky.Mouse Donald.Duck" or similar.

Any advice would be much appreciated!