Results 1 to 6 of 6

Index, match large with multiple criteria pulling wrong record

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2017
    Location
    Dallas, TX
    MS-Off Ver
    Office 365
    Posts
    4

    Index, match large with multiple criteria pulling wrong record

    second try with attached example...

    Hey everyone,
    I have an issue where I am using a combination formula with index, match (with two criteria), and large functions.

    The objective of this formula is to find the player that is at the correct position (defined in $C$4) with a salary that is at or below the value in $C$5 with the nth value (I am looking for top 3, this is the formula for the 1st value) in [Avg Projection]. The formula seems to find the correct value for [Avg Projection], but then returns the name of the first player it finds in the list that has the same [Avg Projection] value, but not necessarily the correct record that satisfies the two criteria. The formula I am using is:

    {=INDEX(Price_List[Player],MATCH(IF($C$4="Flex",LARGE(IF((Price_List[Pos_2]=$C$4)*(Price_List[Price]<=$C$5),Price_List[Avg_Projection]),A7),LARGE(IF((Price_List[Pos]=$C$4)*(Price_List[Price]<=$C$5),Price_List[Avg_Projection]),A7)),Price_List[Avg_Projection],0))}

    Any help would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDEX MATCH & LARGE Functions, Multiple Criteria
    By skyhawk3485 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-19-2018, 09:55 AM
  2. Index, match large with multiple criteria pulling wrong record
    By markclary in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2017, 02:33 PM
  3. Replies: 8
    Last Post: 06-17-2017, 03:28 AM
  4. [SOLVED] INDEX MATCH LARGE with Multiple criteria
    By clachi80 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-14-2017, 03:50 AM
  5. [SOLVED] Using LARGE or MAX inside INDEX-MATCH formula with multiple criteria
    By Big.Moe in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-28-2017, 02:40 AM
  6. Index Match Large formula with multiple criteria
    By Dylan Cooper in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-21-2016, 06:00 PM
  7. Excel 2007 : Index, Match, Large Formula: Multiple Criteria, Multiple Ranges
    By SimpleJack in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2013, 08:54 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