Forum Discussion
Lookup formula not working
Hello all - Hoping all safe! I am trying to use a lookup formula to check if a text string is present in a column cell, and if so, it returns a value TRUE in a different column but the same row. f...
It returns "TRUE" for me. But, you should be able to simplify that formula to:
=ISNUMBER(SEARCH("Need Material",$B3))
=ISNUMBER(SEARCH("Need Material",$B3))