1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. 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)

Discussion in 'Ask an Excel Question' started by Sriram Iyengar, Jul 17, 2017.

  1. Sriram Iyengar

    Sriram Iyengar New Member

    Messages:
    16
    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?

    Attached Files:

  2. rahulshewale1

    rahulshewale1 Member

    Messages:
    93
    hii,

    is this you looking for ?


    Thanks
    rahul shewale

    Attached Files:

  3. Sriram Iyengar

    Sriram Iyengar New Member

    Messages:
    16
    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

Share This Page