'Partial match between 2 column and output yes, no in another column

Trying to do a partial match between the two columns and generate Yes or No if they do have a partial match on the third column
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
