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

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

  1. Herbertsuime

    Wow, beautiful site. Thnx … [url=http://machinalansu.pl/ziola-na-wypadanie-wlosow/]http://machinalansu.pl/ziola-na-wypadanie-wlosow/[/url]

  2. HectorMow

    [url=http://de.detoxyn.org/bad-schussenried-klinik-entgiftung/]http://de.detoxyn.org/bad-schussenried-klinik-entgiftung/[/url]

    Sustain the good job and producing in the group!

Comments are closed.