XLOOKUP Not Finding Associated Value After Cleaning Up Data With Power Query

renee_crozier 

All the hard work by SergeiBaklan, just posting a couple of alternatives for the UTF replacement (in attached file)

// Variant1
  ReplacedUtf = Table.ReplaceValue( Source, each [LinkURL], null,
      (old_value, current_value, replacer) as text =>
          if current_value is null then old_value else
          List.Accumulate( ListReplacmentsTexts, current_value,
              (value,lists) => Text.Replace( value , lists{0}, lists{1} )
          ),
      {"LinkURL"}
  )

// Variant2
  ReplacedUtf = Table.ReplaceValue( Source,
      each if [LinkURL] is null then false else [LinkURL],
      each List.Accumulate( ListReplacmentsTexts, [LinkURL],
              (current_value,lists) => Text.Replace( current_value , lists{0}, lists{1} )
           ),
      Replacer.ReplaceText,
      {"LinkURL"}
  )