Hello,
I've tried to follow the instructions for the search with multiple results:
http://office.microsoft.com/en-us/ex...CL100570551033

However, the data I'm trying to pull a list of is on a separate worksheet. I
need to have the search find the character string I specify and return all of
the results. Basically the example in the tutorial is exactly what I need
except that when I specify a range within the other worksheet I'm only
getting one hit, and its wrong. When I copy the formula down a row it gives
me errors. So far I'm not having any luck. All help is appreciated.
Regards,
Sean