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.
Bookmarks