Is there a formula that will pull specific text from a range of columns in a
single row?

FOr example, I want to copy the words "Transportaion Form" into specific
cell assuming those words are located in Columns C:G of Row 3 .

If "Transportation Form" is not in any of those cells, then I don't want it
to pull anything.

Is this possible?