=IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10)
I have been trying to rework the formula to only
copy the text if the letter "S" appears in the source sheet.

Is that an additional condition or is it a new (the only) condition?


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
Yesterday I was given a solution to a problem I had when copying text from
cells in the source sheet to the destination sheet. The formula:
=IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10)
was to prevent text from copying to the destination sheet if the word
"BLOCK" appeared in the source sheet. I have been trying to rework the
formula to only copy the text if the letter "S" appears in the source
sheet.
I have not had any success. Please help!
Thanks,
Malcolm