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!!

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!!

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!!

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!!

I'm afraid I'm not quite sure what to take out and what to change. I don't
need values from the column next to, so I should take out the parts of the
formula referring to that, but then I still need to search the text strings
in column O for ones that contain (but not limited to EXACT) the text string
from A2.

I've gotten very close with: =VLOOKUP(A5,A2:O4977,15,TRUE)
but I think the formula is looking to a particular row for the value....

"Biff" wrote:

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!!

I still need to search the text strings
in column O for ones that contain (but not limited to EXACT)
the text string from A2.

Post some examples. What is the lookup value and what values in the lookup
table "match".

Biff

"LisaChica" wrote in message
...
I'm afraid I'm not quite sure what to take out and what to change. I
don't
need values from the column next to, so I should take out the parts of the
formula referring to that, but then I still need to search the text
strings
in column O for ones that contain (but not limited to EXACT) the text
string
from A2.

I've gotten very close with: =VLOOKUP(A5,A2:O4977,15,TRUE)
but I think the formula is looking to a particular row for the value....

"Biff" wrote:

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!!