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

G

Gluefoot

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?
 
B

Bob Phillips

=COUNTIF(Sheet2!A:A,A2)

--
HTH

Bob

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