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...