lookup to return multiple cells

I'm trying to find a way to return multiple cells with a lookup function ie

$ bob
% kevin
* alice
* maggy

if I have 2 columns and I want to lookup all the *s in the first column and then return all the corresponding cells in the second column. So in a third cell if I look up * I would see maggy and alice. Does any one know how to do this or if this is even possible.

Thanks

If you look up wildcard characters like "*", be sure to read this: http://support.microsoft.com/kb/214138/en-us