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!

=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!

Try this:

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


--
Biff
Microsoft Excel MVP


"SueK" wrote in message
...
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!

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!