Find Replace tool

[LeoMessi]

Hi Community,

Here is my existing sample dataset:

ID	Exclusion Summary	Reason of Exclusion (Overall)
333333	In	N/A
444444	In	N/A

I want to update the details in "Exclusion summary" and "Reason of Exclusion (Overall)" to: 

ID	Exclusion Summary	Reason of Exclusion (Overall)
333333	Out	Manual (TL)
444444	Out	Manual (IL)

can you please guide?

[FrederikE]

Hey @LeoMessi,

Unless there is any logic behind this that you didn't mention, the best way to solve this is a lookup table. See the attached example. 

[Qiu]

@LeoMessi 
I like your ID😁
There are a few ways to update value.
What will be your logic?