+ Reply to Thread
Results 1 to 2 of 2

Index + Match, Repeating wrong data ???

  1. #1
    Registered User
    Join Date
    05-04-2009
    Location
    Stuttgart, Germany
    MS-Off Ver
    Excel 2003
    Posts
    1

    Smile Index + Match, Repeating wrong data ???

    Hey guys,

    New to the forum and have been looking around for an answer to a problem I'm having (and finding lots of great solutions to other stuff ). Problem is I'm pretty new with Excel functions and am not sure what to search for, but I'm willing to bet you have an easy solution here...

    So on to the issue at hand: I'm building a fairly simple spreadsheet that at this point just needs to collect the top five prices of (example) from each different "region column" and then put those into a "Best of" column. At the top of the best of column is a "Best of Best" with the top 5 overall. All goes perfectly fine using VLookup, Small, Index, and Match functions, until I have a repeat price which ends up in the top 5 anywhere. I need the name to match it's respective price, but say I have the following:

    1.50 Ex. A
    1.55 Ex. B
    1.50 Ex. C

    I need it to list in the BoB column as such:
    1: 1.50 Ex. A
    2: 1.50 Ex. C
    3: 1.55 Ex. B

    And instead with my current function usage I get:
    1: 1.50 Ex. A
    2. 1.50 Ex. A
    3. 1.55 Ex. B

    Obviously in such a list it will be common that multiple different examples have the same price, so whats the fix? See attachment for further details/exact function usage. Thanks a lot in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Index + Match, Repeating wrong data ???

    See attached...

    Note: Formulas in 1st row of each group is confirmed with CTRL+SHIFT+ENTER not just ENTER in order to get the { } brackets. Then it is copied down the group.
    Attached Files Attached Files
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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