Compare Datatables one specific column with other specific Column and Get Matched and Not Matched Records`

Learn Academy Feedback
44

Hi Aksh, this is great, thanks for sharing :slight_smile: Would it be possible to use a similar formula to find partial string matches between sheets? So it would look in a column in DT1 to see if the string contains any of the strings in a column in DT2. e.g. “brand product type description name” in DT1 contains “product type” in DT2. I’m hoping for it to return the string and the cell address of the matched cell in DT2.

1 Like