Skip field if it doesn't meet FIND criteria

**SWMagic** · 04-13-2014, 06:58 PM

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

**newdoverman** · 04-13-2014, 07:12 PM

You can use something like this to get you started. This simple formula searches the column for a string and returns a count of times found.

Formula:

Please Login or Register  to view this content.

Use the above like =if(COUNTIF(A:A,"*xyzstring*")>0, Do this if true, Do this if false)

**SWMagic** · 04-13-2014, 07:27 PM

So what do I do in case of False, that is Skip.

**newdoverman** · 04-13-2014, 07:47 PM

According to my book on VBA.....I don't yet know VBA but am going to try and learn it.

The general structure is as follows. The TRUE and FALSE parts are separated in a Sub routine with the appropriate definitions to start and end the Sub.

If something = "" Then Exit Sub
If something >0 Then.....

Hope this helps.