If you get stuck just post back to this thread.

Biff

"LisaChica" wrote in message
...
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!!