Googlesheets index match with multiple criteria expert needed
Budget: $25 – $50 AUD
Why are these formulae not returning the same result when they should (multi-criteria met)?
=if('3. Sorted by Density'!FP9=TRUE,ifna(index($A$4:$A8,MATCH($A9,FP$4:FP8,0),1),IFNA(index($A10:$A204,MATCH(true,'3. Sorted by Density'!FP10:FP205,0)),"ORPHAN")))
vs
=if('3. Sorted by Density'!FP9=TRUE,ifna(index($A$4:$A8,MATCH(1,($A9=FP$4:FP8)*(FW:FW=FW9),0),1),IFNA(index($A10:$A204,MATCH(0,(true='3. Sorted by Density'!FP10:FP205)*(FW:FW=FW9),0)),"ORPHAN")))
=if('3. Sorted by Density'!FP9=TRUE,ifna(index($A$4:$A8,MATCH($A9,FP$4:FP8,0),1),IFNA(index($A10:$A204,MATCH(true,'3. Sorted by Density'!FP10:FP205,0)),"ORPHAN")))
vs
=if('3. Sorted by Density'!FP9=TRUE,ifna(index($A$4:$A8,MATCH(1,($A9=FP$4:FP8)*(FW:FW=FW9),0),1),IFNA(index($A10:$A204,MATCH(0,(true='3. Sorted by Density'!FP10:FP205)*(FW:FW=FW9),0)),"ORPHAN")))