Finding out whether text is in a list or not
 

Try in C1: =IF(B1="","",ISNUMBER(MATCH(B1,A:A,0)))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Josh Craig" wrote:
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.