+ Reply to Thread
Results 1 to 2 of 2

Match in the query

  1. #1
    Registered User
    Join Date
    08-12-2021
    Location
    Mumba, India
    MS-Off Ver
    OFFICE365
    Posts
    1

    Match in the query

    Dear Team,

    Please find my query in the attachment and below. Please assist.

    Example1
    Below value in A4 and B4 are same, however not in order. I need a function which says it's a match, irrespective of the order. Please assist

    SLYTHERIN|RAVENCLAW|GRYFFINDOR|HUFFLEPUFF gryffindor|hufflepuff|ravenclaw|slytherin

    Example 2
    In respect to the above example, if there is a change ( as below) , the change in B7 is the word Dr Fruits, it should say a no match

    SLYTHERIN|RAVENCLAW|GRYFFINDOR|HUFFLEPUFF gryffindor|hufflepuff|ravenclaw|Dry Fruits

    Best regards,
    Khwaja, Hanif
    Attached Files Attached Files
    Last edited by AliGW; 08-13-2021 at 12:35 AM. Reason: Urgency removed from post.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,306

    Re: Match in the query

    Please Login or Register  to view this content.
    =comare(A3,B3)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 02-17-2019, 05:43 PM
  2. Index and three match query
    By ajayd3v in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-28-2013, 11:11 AM
  3. Index match query
    By jocer in forum Excel General
    Replies: 3
    Last Post: 07-08-2012, 07:17 AM
  4. Vlookup & Match query
    By bluemeg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-15-2010, 09:31 AM
  5. Find and match query
    By controlfreak in forum Excel General
    Replies: 2
    Last Post: 12-02-2009, 01:13 PM
  6. Index & Match query
    By WLM1976 in forum Excel General
    Replies: 12
    Last Post: 12-07-2006, 10:53 AM
  7. INDEX AND MATCH QUERY ?
    By kate in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2006, 08:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1