Find text

[briank]

In A1 I would like a command that searches for text, located in Col B1 within
a range called VLRange1. The cells within the VLRange1 may have the unique
name like "Bob" or it may be in a small memo like "Where is Bob today". I
could not get Vlookup or Lookup or Find to work. Perhaps I'm missing
something. Any help would be appreciated.
A B
1 command Bob
2 command Smith
3 command Jones

[Bondi]

briank wrote:
> In A1 I would like a command that searches for text, located in Col B1 within
> a range called VLRange1. The cells within the VLRange1 may have the unique
> name like "Bob" or it may be in a small memo like "Where is Bob today". I
> could not get Vlookup or Lookup or Find to work. Perhaps I'm missing
> something. Any help would be appreciated.
> A B
> 1 command Bob
> 2 command Smith
> 3 command Jones

Hi Briank,

Could you please tell us:
- what you would like the formula Command) in A1 to return?
- Is VLRange1 the entire Col B?
- Any other information or example :o)
Regards,
Bondi

[briank]

I would like the cell in Column A to state "True" or "False" if the text in
Col B is found in the range VLRange1. Also VLRange1 is on a different
worksheet within the same file at M2:U300. I hope that this helps. Thank
you.

"Bondi" wrote:

>
> briank wrote:
> > In A1 I would like a command that searches for text, located in Col B1 within
> > a range called VLRange1. The cells within the VLRange1 may have the unique
> > name like "Bob" or it may be in a small memo like "Where is Bob today". I
> > could not get Vlookup or Lookup or Find to work. Perhaps I'm missing
> > something. Any help would be appreciated.
> > A B
> > 1 command Bob
> > 2 command Smith
> > 3 command Jones
>
> Hi Briank,
>
> Could you please tell us:
> - what you would like the formula Command) in A1 to return?
> - Is VLRange1 the entire Col B?
> - Any other information or example :o)
> Regards,
> Bondi
>
>

[Peo Sjoblom]

=COUNTIF(VLRange1,B1)>0

if the value in B can be part of a string

=COUNTIF(VLRange1,"*"&B1&"*")>0



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"briank" <briank@discussions.microsoft.com> wrote in message
news:E40B2DDC-5D4F-4AA1-8255-07267FC0D89A@microsoft.com...
>I would like the cell in Column A to state "True" or "False" if the text in
> Col B is found in the range VLRange1. Also VLRange1 is on a different
> worksheet within the same file at M2:U300. I hope that this helps. Thank
> you.
>
> "Bondi" wrote:
>
>>
>> briank wrote:
>> > In A1 I would like a command that searches for text, located in Col B1
>> > within
>> > a range called VLRange1. The cells within the VLRange1 may have the
>> > unique
>> > name like "Bob" or it may be in a small memo like "Where is Bob today".
>> > I
>> > could not get Vlookup or Lookup or Find to work. Perhaps I'm missing
>> > something. Any help would be appreciated.
>> > A B
>> > 1 command Bob
>> > 2 command Smith
>> > 3 command Jones
>>
>> Hi Briank,
>>
>> Could you please tell us:
>> - what you would like the formula Command) in A1 to return?
>> - Is VLRange1 the entire Col B?
>> - Any other information or example :o)
>> Regards,
>> Bondi
>>
>>

[briank]

Countif command worked great. Thank you both for your time.

"Peo Sjoblom" wrote:

> =COUNTIF(VLRange1,B1)>0
>
> if the value in B can be part of a string
>
> =COUNTIF(VLRange1,"*"&B1&"*")>0
>
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey
>
>
> "briank" <briank@discussions.microsoft.com> wrote in message
> news:E40B2DDC-5D4F-4AA1-8255-07267FC0D89A@microsoft.com...
> >I would like the cell in Column A to state "True" or "False" if the text in
> > Col B is found in the range VLRange1. Also VLRange1 is on a different
> > worksheet within the same file at M2:U300. I hope that this helps. Thank
> > you.
> >
> > "Bondi" wrote:
> >
> >>
> >> briank wrote:
> >> > In A1 I would like a command that searches for text, located in Col B1
> >> > within
> >> > a range called VLRange1. The cells within the VLRange1 may have the
> >> > unique
> >> > name like "Bob" or it may be in a small memo like "Where is Bob today".
> >> > I
> >> > could not get Vlookup or Lookup or Find to work. Perhaps I'm missing
> >> > something. Any help would be appreciated.
> >> > A B
> >> > 1 command Bob
> >> > 2 command Smith
> >> > 3 command Jones
> >>
> >> Hi Briank,
> >>
> >> Could you please tell us:
> >> - what you would like the formula Command) in A1 to return?
> >> - Is VLRange1 the entire Col B?
> >> - Any other information or example :o)
> >> Regards,
> >> Bondi
> >>
> >>
>
>
>