Re: Search for first instance of text & return the value
- From: "Biff" <biffinpitt@xxxxxxxxxxx>
- Date: Tue, 13 Jun 2006 21:17:51 -0400
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" <LisaChica@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3D1A4770-ED8F-4163-83E0-36E7D057681B@xxxxxxxxxxxxxxxx
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" <LisaChica@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BAC32874-F4FC-4182-AF92-AF8781E1E414@xxxxxxxxxxxxxxxx
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" <LisaChica@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:373D809E-EC0C-4620-9AF3-49EABB774626@xxxxxxxxxxxxxxxx
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!!
.
- Follow-Ups:
- Re: Search for first instance of text & return the value
- From: LisaChica
- Re: Search for first instance of text & return the value
- References:
- Prev by Date: Re: Vlookup for multiple criteria
- Next by Date: Re: How to smart count a table with words in it!
- Previous by thread: Re: Search for first instance of text & return the value
- Next by thread: Re: Search for first instance of text & return the value
- Index(es):
Relevant Pages
|
