1 Reply Latest reply on Jul 23, 2018 6:45 PM by lei.chen.0

    Match two columns.

    Udayambika Nair

      hi ,

      i have two columns containing Brand NAMES coming from two different Sources.

      The name conventions differ for most of the brands ,even though they are similar brands.

      Capture.JPG

      I want to match both the columns somehow to reduce the red flags.Technically if u see they look different, but actually they are similar brands Except one which is marked in red.Attached is the workbook.

       

      IS there way to do some match functions on both columns ,match the similar brands and reduce red flags as much as possible.

       

      Regards

      ambika