Finding out whether text is in a list or not

J

Josh Craig

Hi,

Simple question, but I can't seem to work it out.

I have data in column A and different data in column B. In C1 I want a
function that says TRUE when the data in B1 is somewhere in column A and
FALSE when the data in B1 can't be found anywhere in column A.

Your help is greatly appreciated.
 
Top