Using Multiple criteria search in same column, getting the opposite data that I'm requesti

Good Evening,

Right now I am trying to draw data based on two criteria in the same column. What I need to happen is, if any cell in column "K" reads "Random Patrol Tour Completed: Hammond Tour Pod 1E ", or"Random Patrol Tour Completed With Errors: Hammond Tour Pod 1E ", I need it to show the value of column "H", in the corresponding row. The formula I have so far is as follows:

=IF(SEARCH(K:K="Random Patrol Tour Completed: Hammond Tour Pod 1E ",OR(K:K="Random Patrol Tour Completed With Errors: Hammond Tour Pod 1E ",)),H:H,"")

now what is happening is it is returning the value for "H" for every cell that DOES NOT feature the two criteria listed above. What am I doing wrong in the formula?

Attached is a sample of the fields i'm utilizing. I know its a lot of text but i'm really just concerned with columns "K" and "H". The rows that are highlighted in yellow are the ones in which i need the formula to pull the data from "H", if the two criteria are present in the same cell in column "K". Any help is greatly appreciated.

Regards,

jdsmith1895

The attached file is empty.

Pete

Sorry about that.

Put this in U1:

Formula:

Please Login or Register  to view this content.

then copy down.

Hope this helps.

Pete