Assign words by selecting a common word

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

I have a raw dump sheet, which has case details. there is a Description Column. I want to insert a column next to in and assign keywords depending on the kind of description.

Example: if the description contains "Service: HTTP Thread Saturation" the Keywords column should update as "Zimba Error"

Can u help me on this

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Vidhya,

Depending on how many different descriptions you have, you could use nested IF's. Like:
If(cell to the left = description A, if yes then use text 1, if not
check if the cell to the left = description B, if yes then use text 2, if not
check ...

Best regards,
Trowa