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

enter image description here

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