Return the Value of One Cell only if a Different Cell Contains a Key Word

[nikSp910]

Hello,
I'm trying to use a contains criteria to pull a time stamp to a new cell. I have tried everything I know. Below is what I'm working with. I'm trying to take the time stamp in the first column and put it in the last column but only if the middle column contains the word "Alerting".

So, start with this:
[TABLE="width: 519"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]CallEventLog[/TD]
[TD]Column1[/TD]
[TD]assigned user[/TD]
[TD]Alert time[/TD]
[/TR]
[TR]
[TD="align: right"]8:38:07 [/TD]
[TD]ACD interaction assigned to SueM[/TD]
[TD]SueM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8:38:07 [/TD]
[TD]ACD - Alerting: SueM[/TD]
[TD]SueM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8:38:07 [/TD]
[TD]Sent to user SueM[/TD]
[TD]SueM[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


End with this:
[TABLE="width: 519"]
<colgroup><col><col><col><col></colgroup><tbody></tbody>[/TABLE]

[TABLE="width: 519"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]CallEventLog[/TD]
[TD]Column1[/TD]
[TD]assigned user[/TD]
[TD]Alert time[/TD]
[/TR]
[TR]
[TD="align: right"]8:38:07 [/TD]
[TD]ACD interaction assigned to SueM[/TD]
[TD]SueM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8:38:07 [/TD]
[TD]ACD - Alerting: SueM[/TD]
[TD]SueM [/TD]
[TD]8:38:07[/TD]
[/TR]
[TR]
[TD="align: right"]8:38:07 [/TD]
[TD]Sent to user SueM[/TD]
[TD]SueM[/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 519"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]CallEventLog[/TD]
[TD]Column1[/TD]
[TD]assigned user[/TD]
[TD]Alert time[/TD]
[/TR]
[TR]
[TD="align: right"]8:38:07 [/TD]
[TD]ACD interaction assigned to SueM[/TD]
[TD]SueM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8:38:07 [/TD]
[TD]ACD - Alerting: SueM[/TD]
[TD]SueM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8:38:07 [/TD]
[TD]Sent to user SueM[/TD]
[TD]SueM[/TD]
[/TR]
</tbody>[/TABLE]
</body>

 

[Eric W]

Welcome to the forum!

Try:

Book1
	A	B	C	D
1	CallEventLog	Column1	assigned user	Alert time
2	8:38:07	ACD interaction assigned to SueM	SueM
3	8:38:07	ACD - Alerting: SueM	SueM	8:38:07
4	8:38:07	Sent to user SueM	SueM
Sheet3

Cell Formulas
Range	Formula
D2	=IF(ISNUMBER(SEARCH("alerting",B2)),A2,"")

 

[nikSp910]

Perfect!! Thanks so much!!

 

[Eric W]

Happy to help!