Query editor replacing values based on another column values

[Martin sherk]

I need to replace values in a column if anything (text or number) is found in another column.

= Table.ReplaceValue(#"Removed Duplicates",each [Remarks],each if [Data] =  then "On Hold" else [Remarks],Replacer.ReplaceValue,{"Remarks"})

i don't know what to type here in: each if [Data] = ?? , i want to say any value in that column.

 

[JGordon11]

maybe

= Table.ReplaceValue(#"Removed Duplicates",each [Remarks],each if [Data] <> null then "On Hold" else [Remarks],Replacer.ReplaceValue,{"Remarks"})