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