Hi all,

I've got a dataset with a column of names. I have another column with PLR_ID and a column with "NAME". I want to replace the names of the first column with the PLR_ID if the name is present in the column "NAME". If the name is not present i want the name of the first column to remain unchanged.

EG I have "Mart Lieder" in the first column, i want to change this name to the PLR_ID if his name is active in the second name column. If his name is not present in the second column i want it remained unchanged.

Can anyone tell me how i can do this?

Hopefully i made myself clear, English isn't my first language

Kind regards,
Onkadonk