Jan 10 2022 05:33 AM
Jan 10 2022 06:16 AM
If names are not matched that is mix of automatic work (any lookup function) and manual corrections where lookup found nothing.
Alternatively Fuzzy Match in Power Query (or perhaps add-in) could be used, but with it also no warranty everything will be found.
Jan 10 2022 11:30 PM - edited Jan 10 2022 11:31 PM
Thanks @Sergei Baklan , any way to match two text based on two or more identical words in both texts, for example, I like drinking coffee, and 2nd text I'm drinking coffee every night, the matching here based on two identical words drinking & coffee, and so o
Jan 11 2022 01:15 AM
Not sure. Without predefined words we need to split each text on array of words; exclude from it "a", "the", "and", etc.; exclude characters like "," and "!"; compare lookup array with lookup array of arrays; find row with two or more matches; based on its position return some value.
If possible that's not easy task.
Jan 11 2022 03:02 AM