Macro/VBA Help needed - finding text in column a, if matched return a code

[Offroadracer_814]

I have a description coming in from my vendors that not consist. Sometimes I get TKT or Ticket in a cell. No sure which function to use.

If c3 contains TKT or Ticket. Then return TKT in d3.

Thanks in advance

Kevin

 

[vcoolio]

Hello Kevin,

Perhaps the following formula placed in D3 and dragged down as far as needed will do the task for you:-

=IF(OR(C3="TKT",C3="Ticket"),"TKT","")

I hope that this helps.

Cheerio,
vcoolio.