Clearing Data from Specific cols

[Howardc]

Hi Rick thanks for getting back to me. The datas in Col a must be cleared

[Rick Rothstein]

Hi Rick thanks for getting back to me. The datas in Col a must be cleared

Then I am afraid Columns P and T will always look like they are blank (they are not as they still contain formulas) until you put data back in Column A. Just so you understand why, this is the array-entered formula you have in cell T2 (as but one example from that column)...

=IF(A2="","",INDEX(Codes!$C$2:$C$15,MATCH(1,IF(Codes!$A$2:$ A$15=Fassets!$A2,IF(Codes!$B$2:$B$15=Fassets!$E2,1 )),0)))

The part I highlighted in red is why the cell looks like it was cleared... when you removed the data in A2, this formula displays "" (which looks blank to the human eye). Now, this is the formula you have in cell P2...

=IF(T2="","",""&T2&"=100")

Note the part I highlighted in red for it... because the first formula above makes T2 display "", this formula will end up displaying "" also (again, until some data is put back into Column A). So, your original question is not really a problem since all formulas are doing what they were designed to do.