Ooops If you mean you want a formula to find the string of words (sentence) in column B of sheet 1 from a paragraph in column B of sheet 2 then return the matching report number, I'm afraid that's beyond my knowledge.