Forum Discussion
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 ...
Hi, Robert!
Just apply this formula in H3, and copy it down:
=IF(COUNTA(J3:N3),IF(COUNT(INDEX(SEARCH(D3,J3:N3),)),"Worked","Re Certify"),"")
If you want in formulaR1C1:
=IF(COUNTA(RC[2]:RC[6]),IF(COUNT(INDEX(SEARCH(RC[-4],RC[2]:RC[6]),)),"Worked","Re Certify"),"")
Blessings!