Previous Topic Next Topic

Assign words by selecting a common word

Closed
Vidhya - Sep 15, 2010 at 12:19 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 16, 2010 at 10:14 AM
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

Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Sep 16, 2010 at 10:14 AM
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