Put this formula in C1 and then copy down as far as you like...

=IF(A1&B1="","",IF(ISERROR(SEARCH("A123",A1&B1))," No","Yes"))

Rick


"S Shipley" wrote in message
...
I have a spreadsheet where column A contains 4 character department codes
i.e. A123 and column B contains multiple 4 character department codes
separated by commas. I want to find the value A123 in either column A or
column B and if found put a Yes in column C and if not found then put a No
in
column C for that row. I have tried several different functions and
combinations of functions but I can't seem to get reliable results.