THANK YOU!! That did the trick!

"Teethless mama" wrote:

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


"SueK" wrote:

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!