Formula for marking an X in the cell that resembles the text in refrenced cell

[Clarab9]

I have a table in excel that automatically gets populated once a Microsoft form is submitted.

The trouble I am having is the cell referenced against, if contains more than one of the three categories it does not plot an x the corresponding cell. I originally used the =IF(D5="Repair","x","") for each cell category but this did not work.


Example of one string in cell

Example when two values are in cell does not work

 

[mrshl9898]

For F5, copied across and down.

FIND will see if a value is anywhere within a cell and return the position of the first character.

=IFERROR(IF(FIND(F$4,$E5)>0.1,"x",""),"")