I want a macro that reads a column to the end. If Col A contains a string, I want to put the contents of Col D into Col E. If it doesn't have that string, simply ignore it.

All I have so far is this:
=IF(ISNUMBER(FIND("xyzstring",A4,1)),C4,)

but obviously this is going to set the field to zero, and I just wish it to be ignored.

Then I want to put this into a loop that goes through all records.

Any help is appreciated.

Paul