They both have to be present. Maybe there is an easier way to do it.

All i need is a formula to read the text in column "K". and if the cell in column "k" contains the text, "tour completed" AND the text "1E", i need it to show the value in column "H" of the same row. example, if cell k11 says "Patrol tour completed, Hammond Tour 1E", then i need it to show the value in cell H11..

Maybe you know a better formula all together?