hi
=IF(OR('Hskp Assign'!C10={"","BLOCK","S"}),"",'Hskp Assign'!C10)

that should cover BLOCK or S.

regards
FSt1

"Malcolm" wrote:

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