finds certain text in a column on one sheet and returns specified text into a cell on another sheet.

I have a workbook with multiple sheets. I am looking for a formula that finds certain text in a column on one sheet and returns specified text into a cell on another sheet. The following formula works for that:
=IF(ISNA((MATCH("LUG",BOM,0)))=TRUE,"DELETE OPERATION","Assemble Lugs to Flanges")

My problem is that I want to add an IF(AND/ or OR) funtction to this problem, or whatever works best. My current formula reads:=IF(ISNA(AND((MATCH("LUG",BOM,0)),(MATCH("FLANGE",BOM,0))))=TRUE,"DELETE OPERATION","Assemble Lugs to Flanges"). Now I want to add IF(AND to search for other text and return specified text into the cell.

Example of what I am trying to do:
=IF(ISNA(AND((MATCH("LUG",BOM,0)),(MATCH("FLANGE",BOM,0))))=TRUE,"DELETE OPERATION","Assemble Lugs to Flanges"),IF(AND(ISNA(AND((MATCH("LUG",BOM,0)),(MATCH("WELD END",BOM,0)))))=TRUE,"DELETE OPERATION","Assemble Lugs to Weld End")

If the text "Lug" and "Flange" are in the BOM column return certain text into given cell, but if the BOM column contains text "Flange" and "Weld End" return different text into the same given cell. Basically I want to add multiple formulas into a certain cell in a particular sheet in my workbook using the above referenced formula.