Return specific text if a different text is contained anywhere in a range of cells

I need to create a formula that will return a specific text ("FSC No.ABC-123-456") in one cell (C9) if the text "FSC" is found anywhere in another range of cells (C2:C7).

Some cells in the range will just be numbers and/or letters, others will have "FSC" as part of the cell, but usually not at the beginning or end. If "FSC" is not found, do nothing.

I tried the formula: =IF(ISNUMBER(SEARCH("*FSC*",C2:C7)),"FSC No.ABC-123-456",””) but that returned an error.
I have also tried a couple of VLOOKUP functions, but nothing works.

I've attached an example
test.xlsx

That worked perfectly - thank you so much!