Mar 07 2019 11:15 AM - edited Mar 07 2019 11:17 AM
HELP!
In a table of data, I need to match 3 variables and select the corresponding value.
Between the 3 variables, there should only be one match.
For the life of me, I can't sort this out :(
I've simplified in the attached screenshot, and attached a sample excel.
Mar 07 2019 12:11 PM - edited Mar 07 2019 12:45 PM
Hi
=SUMPRODUCT(($A$3:$A$8=A13)*($B$3:$B$8=B13)*($C$2:$F$2=C13)*($C$3:$F$8))
To get the expected result in D15 you have to change the text in B15.
Mar 07 2019 02:10 PM
I get a #VALUE! result with that, when trying as either a formula or array formula.
Screenshot attached.
Mar 07 2019 02:18 PM
SolutionGot it!
=INDEX($C$3:$F$8,MATCH(1,(A13=$A$3:$A$8)*(B13=$B$3:$B$8),0),MATCH(C13,$C$2:$F$2,0))
Screenshot attached.
Mar 07 2019 08:31 PM
I forgot to mention that you have to delete the hyphen in C6 and D6
Mar 07 2019 02:18 PM
SolutionGot it!
=INDEX($C$3:$F$8,MATCH(1,(A13=$A$3:$A$8)*(B13=$B$3:$B$8),0),MATCH(C13,$C$2:$F$2,0))
Screenshot attached.