futurejock
New Member
- Joined
- May 31, 2009
- Messages
- 20
how do I write 3 columns of "find text" arrays, which include phrases and singular words, which must be preserved or found exactly?
How do I return the search/sort so that
if A1=instance yes then "xxx", if no then test B1
if B1=instance yes then "xyz", if no then test C1
if C1=instance yes then "zzz", if no then stop
then run
if A1=yes and B1=yes, then "abc"
if A1=no and B1=yes, the "def"
etc.
---definition of match = any single instance or more of any item on a list
---definitition of qualifies for match = all letters of word in correct order, complete, and all words in correct order, select no partial match of a word, and no composite words in either direction
---qulaifier= disrespecting any case sensitivity (in either direction)),
A1
Data= strings of text, each cell is unique
B1
return=formula searches in column A for words or phrases
C, D, E
list(s)=unique words or phrases
How do I return the search/sort so that
if A1=instance yes then "xxx", if no then test B1
if B1=instance yes then "xyz", if no then test C1
if C1=instance yes then "zzz", if no then stop
then run
if A1=yes and B1=yes, then "abc"
if A1=no and B1=yes, the "def"
etc.
---definition of match = any single instance or more of any item on a list
---definitition of qualifies for match = all letters of word in correct order, complete, and all words in correct order, select no partial match of a word, and no composite words in either direction
---qulaifier= disrespecting any case sensitivity (in either direction)),
A1
Data= strings of text, each cell is unique
B1
return=formula searches in column A for words or phrases
C, D, E
list(s)=unique words or phrases