Good Afternoon,

I have been racking my brain trying to figure out this formula. What I am in need of is a way to see if a certain text string is present in column "k", for example. And if it is present I need to extract the data from column "H", in the same cell. For example, If K1 contains the text "clock tour completed" anywhere in the cell, i need to extract the data from that SAME Cell, but in column "H" and i need to do it close to 1,000 times. So there should be around 1,000 cells that contain the text "clock tour completed" somewhere in the cell. and i need to know the value in column H for that same cell, the same amount of times.

Regards,

JDSmith