Thank you very much! I'm goin to work with this and see if I can modify it
to work for me. Been a long time since I've done this, I'm pretty rusty.
Thanks so much for the help!

"Biff" wrote:

Sounds like this:

http://tinyurl.com/lrrpt

There's a sample file included in that thread. It may not be EXACTLY right
for your situation but the basic technique is what you're looking for and
you can modify the formula to better suit your needs.

Biff

"LisaChica" wrote in message
...
This is a two part question...
Here's what I have:
I have a list of product numbers in col. A. In col. O I have a list of
file
names that contain the product numbers as well as additional characters.
I
need a formula that will search col O for the first instance of the text
in
cell A2 and return that value.

The next formula will return all instances that contain the text found in
A2.

Please help, I have a deadline of this evening for this and I've been
wracking my brain and discussion Groups for this. Thanks so much!!