• 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.

Similar data between two sheets (Near Match & Exact Match)

Sriram Iyengar

New Member
Hi All,

I have two worksheets. I need to find out if any of the terms present on the worksheet titled as EX1- Yes are present on the sheet titled as EX2 (near match or exact match both).

I tried a vlookup but i don't think that is the solution. Can you please help?
 

Attachments

  • EX2 Identify_Brandedness-Adwords+Feed.xlsx
    402.4 KB · Views: 2
Damm thats awesome but i made a small error.

I am looking for the output on sheet titled as Ex2 - if any of the terms of sheet Ex1-Yes are present on Ex2 (exact or near match) then it should say Match Found or Match Not Found

for example

Ex2 has Sriram Iyengar
and Ex1- Yes has
Shahrukh Khan
Gulshan Grover
Ram

It should say Match Found on Ex2 next to Sriram Iyengar

and if
Ex2 has Rahul Shewale
and Ex1- Yes has
Shahrukh Khan
Gulshan Grover
Ram
It should say Match not Found on Ex2 next to Rahul Shewale
 
Back
Top