+ Reply to Thread
Results 1 to 8 of 8

Getting error in index-match formula

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Getting error in index-match formula

    Hi friends,
    I want to retrieve data from MSL folder-Masterlist to the folder ABC-Result sheet std. 12 a with a help of index-match formula.
    If I enter a ID in column ‘B’ then I want the related information in column ‘c’. I have inserted a index-match formula in column ‘b’ ABC/Result/Result sheet std. 12 a but getting error.

    Any help will be appreciated.

    Thanking you.
    Attached Files Attached Files
    Sincerely,

    mso3

  2. #2
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Getting error in index-match formula

    Hi,
    I have amended the formula but still there is a error. Please see the following formula and suggest me a correction.

    Please Login or Register  to view this content.
    Thanking you in anticipation.

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Getting error in index-match formula

    The last range should not be in an index..

    Try
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Getting error in index-match formula

    Hi Jonmo1,
    Sorry, still it's giving error.

    Please do the necessary amendment , test it and suggest me the correction.

    Thank you.

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Getting error in index-match formula

    Misplaced '

    ='INDEX(C:\Users\Mukesh\Desktop\MSL\[MasterList.xlsm]Data'!$a$4:$a$50000,MATCH('C:\Users\Mukesh\Desktop\ABC\RESULT\[RESULT SHEET std. 12 A.xlsm]Information'!$b4,'C:\Users\Mukesh\Desktop\MSL\[MasterList.xlsm]Data'!$A$4:$A$50000,0))

    Should be
    =INDEX('C:\Users\Mukesh\Desktop\MSL\[MasterList.xlsm]Data'!$a$4:$a$50000,MATCH('C:\Users\Mukesh\Desktop\ABC\RESULT\[RESULT SHEET std. 12 A.xlsm]Information'!$b4,'C:\Users\Mukesh\Desktop\MSL\[MasterList.xlsm]Data'!$A$4:$A$50000,0))

  6. #6
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Getting error in index-match formula

    Hi Jonmo1,
    Excellent! I also didn't notice the quote before index. Sorry for that.

    Thank you for solving my problem.

  7. #7
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Getting error in index-match formula

    Hi Jonmo1,
    Excellent! I also didn't notice the quote before index. Sorry for that.

    Thank you for solving my problem.

  8. #8
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Getting error in index-match formula

    You're welcome.

+ 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: 3
    Last Post: 05-02-2013, 01:31 AM
  2. [SOLVED] #REF! Error in INDEX & MATCH Formula!
    By Rajeshkumar R in forum Excel General
    Replies: 6
    Last Post: 06-09-2012, 09:00 AM
  3. error in index+match formula
    By j_r_m_c in forum Excel General
    Replies: 5
    Last Post: 02-14-2011, 04:30 PM
  4. I get an error in (Index & Match) Formula
    By MAHMUZ in forum Excel General
    Replies: 11
    Last Post: 11-14-2010, 05:41 AM
  5. Index and Match Formula gives #NUM! Error
    By Quniquez in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-03-2010, 09:29 PM

Tags for this Thread

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