Spreadsheet Formula and Data Manipulation

I'm seeking an expert proficient in Excel to apply specific spreadsheet formulas to achieve complex data manipulation. The primary task involves applying lookup/match formulas in seven columns of my spreadsheet and taking action on seven correlated columns based on the matched results. When a match for the word "TRUE" is found in the "Phone1DNC", "Phone2DNC", "Phone3DNC", "Phone4DNC", "Phone5DNC", "Phone6DNC", "Phone7DNC" columns, the cell data in the corresponding columns, "Phone1", "Phone2", "Phone3", "Phone4", "Phone5", "Phone6", "Phone7" must be completely removed. Your knowledge of spreadsheet data manipulation will be an essential asset to this task, specifically skill with formulas. Precision and attentiveness to detail are crucial as the quality and accuracy of formulas applied will directly affect the utility of manipulated data.