finding substring from the some column and updating another column based upon that

[mayank.ahuja]

Hi

I am a bit new to excel functions, so want some help.

I am writing down one of of the cell's value ( e.g; position D3) in my excel sheet. I have written the value like you can understand my problem.



The following code is present in work log column of the report extracted through Remedy.
And I want to find this particular code eTS1FNUAT. If its preant in this particular cell then ,
I want to write in the other column corresponding to it the relevant code, like for this
it would be Functional_Problem_Ticket.

There can be other value of the substring like eTS1DBUAT, which indicates this is Database_Problem_Ticket.

The first 3 character will always be eTS and 4th character can have value out of 1, 2, 3 .
5th, 6th character can have value out of FN, DB, AC .
rest last 3 character 7, 8, 9 can have value only UAT

But there will be only one code will be present in the cell, that is for sure.
like either eTS1FNUAT or eTS1DBUAT
In short I want to look for %eTS?FN% or %eTS?DB% , %eTS?AC% .


Code written the bold above is my D3 cells value and similar value is there in another row under the same column.
like in D4, D5, D6 , etc.


Or, in nutshell, I have to tell the "ticket type resolved" depaning upon this worklog column in my excel sheet, which contains ticket resolution code.