Add Text in column U only if in column J contain specific word

[vinzent]

Hi to all, I need your help with this case:
I need to add the text "Urgent" in the end of the word in column U only if in column J contain specific text "Value" or "Error" or "Mode".
Example: In cell J2 contain the data "Value" and normally the text in cell J2 is "Type 1". Just I need to put "Type 1 Urgent"
Thank You for your help.

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[Fluff]

How about

Sub vinzent()
   With Range("U2:U" & Range("J" & Rows.Count).End(xlUp).Row)
      .Value = Evaluate(Replace(Replace("if((@=""Value"")+(@=""Error"")+(@=""Mode""),#&"" Urgent"",#)", "@", .Offset(, -11).Address), "#", .Address))
   End With
End Sub

 

[vinzent]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

Thank You for your feedback, I will consider this for next time.

 

[vinzent]

How about

Sub vinzent()
   With Range("U2:U" & Range("J" & Rows.Count).End(xlUp).Row)
      .Value = Evaluate(Replace(Replace("if((@=""Value"")+(@=""Error"")+(@=""Mode""),#&"" Urgent"",#)", "@", .Offset(, -11).Address), "#", .Address))
   End With
End Sub

Thank You for your time, this is working for me

 

[Fluff]

Glad we could help & thanks for the feedback.