Hi,
I need to pull in numbers based on 3 multiple criteria. I have tried 3 variations of a formula, but all result in a value error. See below:
In my document (attached), I need to pull a number if there are matches between (1) the partner name in the top red box and the column of partner names (2) the software and the row of software, and (3) the "SUM" column for each software.
Formula 1 =INDEX($F$9:$I$13, MATCH($C7, IF(AND($F$6:$I$6="SUM",$E$9:$E$13=$B$2),$F$8:$I$8),0))
Formula 2 =INDEX(OFFSET($F$9:$F$13,, MATCH($C8&"SUM",$F$8:$AM$8&$F$6:$AM$6, 0)-1), INDEX(F$9:F$13, MATCH($B$2, $E$9:$E$13, 0))
Formula 3 =INDEX($F$9:$AM$13,MATCH($C9&"SUM",$F$8:$AM$8&$F6:$AM$6,0))
Thanks!
Bookmarks