Finding a Value

[SueK]

This seems to be an easy Excel issue, but I can't find a way to do it. I
want to determine if a value in column A appears anywhere in column B. If it
does, I want to return the column A value in column C. If it doesn't, I want
to return "OK". I am assuming there should be some nesting function in an IF
function, but I can't figure it out!

 

[Teethless mama]

=IF(COUNTIF(B:B,A1),A1,"OK")

 

[T. Valko]

Try this:

=IF(COUNTIF(B$1:B$100,A1),A1,"OK")

 

[SueK]

THANK YOU!! That did the trick!

=IF(COUNTIF(B:B,A1),A1,"OK")