Search multiple Text Criteria in one column, and if found, rename it in a different column

I have to search for data in column Y that either contains the text "HYBRID", "GO?????" (the question marks are random numbers or spaces), or "NEP????????LVL3". If it finds HYBRID, it should post "Interconnect" in Column AD. If it find "GO????", it should post "Red" in column AD, and if it finds "NEP????", it should post "Orange" in column AD. All my formulas are created in column AD, but it is searching for the criteria described above from column Y.

My code is not producing the correct results. It finds HYBRID, but produces an output of RED, not INTERCONNECT. It finds GO????? and NEP?????, but produces an output of INTERCONNECT. What is wrong with this code?

Please Login or Register  to view this content.

I'd appreciate some direction and HELP.
Greg

Your code basically says "If it's an error returned when searching for hybrid then return Interconnect otherwise check if an error is returned when Finding GO?????? Return Red etc, remove all the ISERROR parts and see what happens then add one ISERROR at the front of the checks.

Hi gbloemke
You could use a loop like the one below instead of formulas. See what you think
Cheers

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

John, your code appears to be working well. I'm not so great at using Dim code, but this will help me learn to understand it better.
I have one additional question. I like this code that you provided below to include an additional element. I'd like to have it look for the text of "NEP" AND "LVL3". In other words, it must contain both pieces of text to return Orange.

Please Login or Register  to view this content.

Possible?
Thanks,
Greg

Try:

Please Login or Register  to view this content.

OMG! All works good. Thanks a lot John.

You're welcome. Glad to help out and thanks for the feedback.

John,

I was searching for using a Instr VBA code but this works much better for my needs. Question, if I wanted to add a third condition whereas neither of the previous two conditions were met that the cells value is "No" how would I go about doing that? I tried Else but I am still getting the hang of Dim code.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.