Formula that will return a result based criteria found through searching multiple cells

Your request is not too clear to me, sorry Perhaps you could include a few examples of your expected outcome and how you arrived atthem?

Are you, for instance, trying to find RED text in a cell and then return something based on that "find"?

Excel cannot "see" colors, so unless there is some logic to how you change the colors, you will need someone to put some VBA together for you

The colour doesn't matter --- i just used red text to hightlight the criteria.

Essentially I need the formulas to search through columns A,C&D for any of text in the `Search for`column below and return the result in the column E from the `Return Result`column below. I was trying to use VLookup but i don`t think Vlookup can search through 3 different cells.

Search for

ROC
24200
TC
EO
ARP
NCS
CCD
Trade Receipts
MNPAD
48ELO
GAPOSA


Return Result
ROC
AR
TC
EO
ARP
NCS
CCD
Total
PAD
AR
AR

I added your criteria to G2:G12, you can movethem where you want, just adjust the references in the formula...
=IF(OR(ISNUMBER(SEARCH("*"&$G2&"*",A2,1)),ISNUMBER(SEARCH("*"&$G2&"*",C2,1)),ISNUMBER(SEARCH("*"&$G2&"*",D2,1))),E2,"Not Found")

OK replace the formula with this array formula...
=IF(OR(ISNUMBER(SEARCH("*"&$G$2:$G$12&"*",A2,1)),ISNUMBER(SEARCH("*"&$G$2:$G$12&"*",C2,1)),ISNUMBER(SEARCH("*"&$G$2:$G$12&"*",D2,1))),E2,"Not Found")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.