Searching for unknown text string in a range and then matching it to a reference table

Colors.xlsxIn separate cells would work. My raw data is transposed though. Sorry, I don't know how to make that table you just showed but my data shows up like this:

A....B....C....D....E
red..<>...<>..blue..<>
<>..grey..<>...<>..<>
<>..<>...green..<>..<>
<>..grey...<>...<>..pink

Is there a way to make it show up 'red' and 'blue' for the first row, 'grey' for the second, 'green' for the third, 'grey' and 'pink' for the fourth row, etc?

Thanks!