• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Criteria based on partial text match

Nikola

New Member
I want to get value from Sheet2 G column, based on partial match between text from Sheet1 B column and Sheet2 C column. I would also add another column in Sheet2 with keywords, in order to make matching easier, because sometimes the text between Sheet1 B column and Sheet2 column is completely different. Is this possible?


Value from Sheet2 G column into Sheet1 G column based on match between Sheet1 B column and Sheet2 C column + "Keyword" column (column I):




Thanks in advance.
 

Attachments

  • sample3.xlsx
    126.6 KB · Views: 6
Last edited:
Back
Top