Check for a word
What do you have for the "new formula"?
Kashyap wrote:
Now formula is not working at all..
"Glenn" wrote:
Kashyap wrote:
=IF(ISERROR(SEARCH(B10,D10)),0,1) - This formula will search a word even
though something else is prefixed/suffixed to the word
where as
=INDEX($H$1:$H$25,MATCH(0,--ISERROR(search(" "&$H$1:$H$25&" "," "&B1&"
")),0))
- This will not serch if something else is prefixed/suffixed to the word.
For Eg., - Take a word Kashyap
if in a sentence word is Kashyap# then 1st formula detects where as 2nd
doesn't..
How to make 2nd formula detect words as 1st?
Remove the
" "&
and
&" "
from both parts of the formula.
|