find a value from 1 column in another column on another sheet
 

I need to see if the value of cell in a column on sheet1 is also in a column
on sheet2, if it is I want it to return a value of TRUE. Is there a function
I can use for this?

find a value from 1 column in another column on another sheet
 

=COUNTIF(Sheet2!A:A,A2)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Gluefoot" wrote in message
...
I need to see if the value of cell in a column on sheet1 is also in a
column
on sheet2, if it is I want it to return a value of TRUE. Is there a
function
I can use for this?