Re: Search for first instance of text & return the value
- From: LisaChica <LisaChica@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 13 Jun 2006 15:51:02 -0700
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:
- References:
- Prev by Date: Vlookup for multiple criteria
- Next by Date: Re: All Capitals
- 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
|
