+ Reply to Thread
Results 1 to 11 of 11

Index match with multiple criteria (text not return)

  1. #1
    Registered User
    Join Date
    10-31-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Index match with multiple criteria (text not return)

    DEAR ALL,

    I HAD FORMULATED INDEX, MATCH FORMULA & RETURN VALUE IS TEXT VALUE. BUT IF TEXT STRING IS VERY LONG, THEN RETURN VALUE IS SHOWS LIKES THIS "############################". PLEASE HELP ME TO RESOLVE THIS ISSUE.
    A B
    1 Location Text
    2 Chennai Chennai, on the Bay of Bengal in eastern India, is the capital of the state of Tamil Nadu.
    3 Madurai Madurai is an energetic, ancient city on the Vaigai River in the South Indian state of Tamil Nadu. Its skyline is dominated by the 14 colorful gopurams (gateway towers) of Meenakshi Amman Temple.

    INDEX(B2:B3,MATCH("Madurai",A2:A3,0),MATCH("Text",B2:B3,0)

    Regards,
    Balaji K

  2. #2
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    349

    Re: Index match with multiple criteria (text not return)

    Hi dear,

    welcome to forum, could you please upload a sample workbook.
    If answer helped you say Thanks by Add Reputation

  3. #3
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Index match with multiple criteria (text not return)

    Try this
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    10-31-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Index match with multiple criteria (text not return)

    I cant upload my file due to disabled in attachment content in this forum.

  5. #5
    Registered User
    Join Date
    10-31-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Index match with multiple criteria (text not return)

    Please find the attached excel file
    Attached Files Attached Files

  6. #6
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Index match with multiple criteria (text not return)

    Hi
    Please clarify your question. What is it that you want to get and from what data?

  7. #7
    Registered User
    Join Date
    10-31-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Index match with multiple criteria (text not return)

    I need data from sheet2 to sheet 1. so I used INDEX, MATCH function for mapping the data. But data is not mapping in Sheet1 and shows error like this ##############. How to resolve this issue.

  8. #8
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    349

    Re: Index match with multiple criteria (text not return)

    Hi Please see attached file,

    looking for like this?
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    10-31-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Index match with multiple criteria (text not return)

    Really thank you very much. this is the exact thing I need. What changes did u made it in the file. Kindly explain.

  10. #10
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    349

    Re: Index match with multiple criteria (text not return)

    Sounds good,

    i have just formatted your cell as Number please see attached.
    Attached Images Attached Images

  11. #11
    Registered User
    Join Date
    10-31-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Index match with multiple criteria (text not return)

    Thank you very much..

+ 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. Index and match formula, attempting to return results with multiple criteria.
    By mahalek1976 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-02-2017, 12:43 AM
  2. [SOLVED] Index/Match with Multiple Criteria and Multiple return values
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2015, 10:27 AM
  3. [SOLVED] Return Multiple values from a column with index and match, and search criteria
    By marcusduton in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-15-2015, 09:59 PM
  4. SOS:Return multiple values against multi criteria match and index function
    By nitesh_inin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-26-2012, 05:45 PM
  5. Replies: 3
    Last Post: 06-15-2012, 04:19 PM
  6. [SOLVED] Return a value:index/match against multiple criteria on another sheet
    By Southfish in forum Excel General
    Replies: 3
    Last Post: 04-30-2012, 11:08 PM
  7. Replies: 3
    Last Post: 08-17-2010, 02:54 PM

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