if(isnumber(search("word *";B1);sheet!$A$1) with no characters preceding "word"

I use if(isnumber(search("word *";B1));sheet1!$A$1) functions a lot to find specific words after which a random word follows (that's why I use the wildcard "*"). I use this to automatically provide c...