Closed Thread
Results 1 to 5 of 5

Need help understanding "Index" and "Match"

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    normal, il
    MS-Off Ver
    Excel 2010
    Posts
    66

    Need help understanding "Index" and "Match"

    Hello All

    I am not sure if it is appropriate to ask for helping understand how to use Excel functions.

    I was given this formula to help create a unique list:

    =IFERROR(
    INDEX($C$5:$X$241,
    MATCH(ROW(BX1), $J$5:$J$241,0),
    MATCH($K$5, $C$5:$X$5,0)),"")


    It works.... but I dont understand how. I am having trouble with another issue (I have it posted it here on the site that hasnt been solved yet) and I am hoping to leverage this to hopefully resolve my other problem.

    This is what I understand...
    INDEX($C$5:$X$241 is setting the area within the excel document where the forumla is to be applied.
    BX1 is just a way to keep track of the rows.
    0 is saying it needs to be an exact match.
    $J$5:$J$241 contains a running total in my data that is a running total of a unique entry (so if there were 100 data entries, but only 5 were unique, that column would have the numbers 1-5).

    I don't understand...
    MATCH($K$5, $C$5:$X$5
    Why is the first part only referring to one cell?

    In my data that one cell has a lot of duplicates, so I don't understand how it can come up with a uique value.

    How is that getting the correct information? I mean it works... but i am missing the logic.

    thanks for your help
    Joanne

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,217

    Re: Need help understanding "Index" and "Match"

    This is a duplicate post - see the Forum Rules about this.

    Pete

  3. #3
    Registered User
    Join Date
    04-23-2013
    Location
    normal, il
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Need help understanding "Index" and "Match"

    gosh, i thought i had a gltich. and i didnt realize i double posted. give me some time to delete this post. thanks for letting me know!!

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,217

    Re: Need help understanding "Index" and "Match"

    You can't delete a thread yourself - you can send a PM to one of the moderators and ask them to do it for you (however, that will reduce post counts - they may just close the thread to prevent anyone else from posting here). You can see a list of moderators currently online on the Home page (they are coloured green).

    Hope this helps.

    Pete

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,055

    Re: Need help understanding "Index" and "Match"

    Thanks Pete, I will close this now, please continue on the other thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  2. Strings Variables in Range("A1").Formula = "=index/match" ?
    By nadnerb5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2012, 05:07 PM
  3. [SOLVED] Variable "sheet-name" and "range-name" wanted in INDEX/MATCH-function
    By Fiebuls in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-01-2012, 04:09 PM
  4. Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  5. Replies: 0
    Last Post: 07-09-2009, 04:07 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