Index/Match only returning results from 1st in array cosntant

Hi again! I have a new challenge and I'm stumped. In my spreadsheet I have data scattered between cells C5:T5 in this case and I'm searching through it trying to match colors from a hardcoded array. The following formula only returns the value of the cell if the word yellow is in one of the cells between C5:T5. What am I doing wrong?

=IFERROR(INDEX(C5:T5,MATCH({"*yellow*","*red*","*blue*","*black*","*camo*","*orange*"},C5:T5,0)),"")

Thanks SO mcuh!!!

Hello and welcome to the forum.

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

Try this in Z4:

=IFERROR(INDEX({"yellow","red","blue","black","camo","orange"},MATCH(1,COUNTIF(C4:T4,{"*yellow*","*red*","*blue*","*black*","*camo*","*orange*"}),0)),"")

Drag the formula down.

63falcondude, Thank you SO much!!! I took it a step further to match the color and the word webbing to make sure it is pulling the right one and boom with your help it works!!! Thanks again!!!

Here is the revised formula if someone else could benefit from it.
=IFERROR(INDEX({"yellow","red","blue","black","camo","orange"},MATCH(1,COUNTIF(C4:T4,{"*yellow*","*red*","*blue*","*black*","*camo*","*orange*"} &"webbing"),0)),"")

You’re welcome. Happy to help.