I am looking for a formula that will allow me to find a certain word in a column of data. Specifically I want to find the cells that has the word 'Life Estate' in any cell in a particular column. I tried an if statement but could not get it to work. I want the answer to be either 'YES' or 'NO' in a separate column. How do I do that?