You'll want to use either FIND (case-sensitive) or SEARCH(non-case-sensitive)

For instance, if A1 = "This is a test"
and A2 = "is"
=IF(ISNUMBER(SEARCH(A2,A1)),"Text found","Not found"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Alyssa" wrote:

I am attempting an IF lookup for a list of cells that have letters in them. I
know how to say IF the cell equals (=) a certain letter, but is there a way
to say IF the cell contains a certain letter?