How to copy data from 1 worksheet to another if cell contains matching text (not exact match)

How would I go about copying a unique value from one sheet to another.

For example, I have a unique value in Cell B in Worksheet 1, I’d like to return a cell from Worksheet 2 if Cell F contains the a part of the text that is within Cell B in Worksheet 1.

Let’s just say the value in Cell B worksheet 1 is – XYZ and the value in Cell F Worksheet 2 is this-link-contains-pics-for-XYZ-product. How would I return the value in cell F in Worksheet 2 to Cell C in worksheet 1?

Thank you.

By: Haithem

Leave a Reply

Your email address will not be published. Required fields are marked *