Find text

B

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
 
B

Bondi

briank said:
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
Click to expand...

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 :eek:)
Regards,
Bondi
 
B

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.
 
P

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
 
Top