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

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

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

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

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