change text in column for particular condition

[abraham30]

Hello Everyone!

In attached sheet, want to populate a new name as 'VACCINE' for column 'DNAME' (irrespective of text present or absent) when encounter the text as 'AVCM_12' or 'CHINA_11'
in column 'DEPTNO'

Advance thanks

[ragulduy]

Please Login or Register  to view this content.

[Debraj Roy]

Hi Abraham,

try this..

Please Login or Register  to view this content.