compare 2 cels that contain certain text

[gyagos]

All,
I am trying to figure out how to go about this. I need to add a column and if Column "E" contains the word Printer and column "D" contains "OWB", i need to display "OWB PRINTER". If it doesnt match than i can just put "OTHER
Some examples below.

Column "D" Column "E"

OWB Workstations Crown

Konica Minolta Printer/Fax/Scanner

<tbody>
</tbody>

OWB Workstations West Covina

HP JetDirect Printer

<tbody>
</tbody>

OWB Workstations Austin

Ricoh Aficio/IPSiO Network Printer

<tbody>
</tbody>

OWB Bank Branches

HP JetDirect Printer

<tbody>
</tbody>

Thanks in advance

 

[Fluff]

Hi & welcome to MrExcel.
How about

Sub OWBPrinters()
   Range("F:F").Insert
   With Range("F2", Range("E" & Rows.Count).End(xlUp).Offset(, 1))
      .Value = Evaluate(Replace(Replace("IF(ISNUMBER(SEARCH(""OWB"",@d))*ISNUMBER(SEARCH(""Printer"",@e)),""OWB Printer"",""Other"")", "@d", .Offset(, -2).Address), "@e", .Offset(, -1).Address))
   End With
End Sub

 

[gyagos]

Thank you for the quick response. Works like a charm

 

[Fluff]

Glad to help & thanks for the feedback