Forum Discussion
Return value based on matching text
Hello everyone, I have sheet contains the correct name and number of clients, another sheet contains clients names only but names are not 100% matches with 1st sheet. I need to return client number f...
Thanks SergeiBaklan , 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
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.
- Thanks SergeiBaklan, appreciated your reply.