I appreciate that this is quite a large question but was wondering if
anyone could help. Has anyone written or know of a search function
which will display multiple results?

What I would ideally like to be able to do is type in part of the
information within a cell and for a function/script to look for any
cells containing this information. Then display the exact contents of
any matching cells.

E.g. if a cell in a worksheet contained the names "John Smith" and
"Dave Smith" I would like to be able to type Smith into one cell and
for both "John Smith" and "Dave Smith" to be displayed elsewhere.

There must be an easy way to this that I'm just missing, Vlookup and so
on require that the exact information is typed in and even then will not
display multiple results. Apologies for length, but it's quite a
specific problem.


--
se01rw
------------------------------------------------------------------------
se01rw's Profile: http://www.excelforum.com/member.php...o&userid=31403
View this thread: http://www.excelforum.com/showthread...hreadid=511698