Formula Assistance: Maybe I'm making this hard...

Hello everyone,

I have a spreadsheet that I'm making that relies on some given data from a database that needs to be translated properly. Refer to the attached document for an example of this and some formulas I had dabbled with: (its all hypothetical)

What I want is a formula that will ultimately apply a value to an entire row based on the "dates completed" and the "affiliate name".

What we used in our Macro: 

=IF(RC[1]="Worked",IF(OR(ISNUMBER(SEARCH(RC[-3],RC[3])),ISNUMBER(SEARCH(RC[-3],RC[4])),ISNUMBER(SEARCH(RC[-3],RC[5])),ISNUMBER(SEARCH(RC[-3],RC[6])),ISNUMBER(SEARCH(RC[-3],RC[7]))),"Worked","Recertify"),"")

There are similar iterations but here is what its supposed to do:

When we retrieve the data it already tells us "Worked" or its blank, meaning it hasn't been worked. Since its not worked it doesn't need a status. But if it has been worked it needs to be labeled as worked, but every once in a while there is something that needs to be re certified because we see in our data that its been retrieved multiple times from other affiliates. But the data does't say that, it just says "worked". Instead we want the formula to find that it needs to be re certified using columns 10,11,12,13,&14 that will have the necessary data.

So, If the cell says "worked" then find the "Affiliate Name" in the "Dates Completed" adjacent cells. If it isn't there, then change the value to "Recertify" If it is there then keep it as "worked".

Then I need a way to apply this formula to an entire column of cells  and possibly into a Macro.

Driving me up the wall trying to figure this out...

Appreciate any assistance.