You can nest:

=IF(ISNUMBER(SEARCH("Wrong",C2)),"Wrong",IF(ISNUMBER(SEARCH("Missing",C2)),"Missing",IF(ISNUMBER(SEARCH("Damage",C2)),"Damage","Not an OFQ"))))