I have many columns of Info. I would like to be able to look for zero values
in a col. say col. A and change the value in the equivalent cell in col.L to
zero as well. Is there a formula or a quick way to do this as there are many
rows of info.

Thanking you in anticipation,
Eqa