IF/AND formula with an index match.

Visitor

Hey there I am trying to change formulas to an index match so that when I move the data around it can go to the correct column and row. 

 

So far I have this for the first formula, I have changed it around so many time but it keeps giving me an error. 

=IF(STDEV(INDEX($A$17:$ACX$861,MATCH(A18,$A$17:$A$861,0),MATCH(ADA1&ADA2&ADA3&ADA4&ADA5&ADA6&ADA7&ADA8&ADA9&ADA10&ADA11&ADA12&ADA13,$A$17:$ACX$17,0))=0,1,0),"")

 

Picture below is the original formula in the data. 

fjsh25_1-1634838293755.png

 

I am also trying to do the same for this formula below:

=IF(INDEX($A$17:$ACX$861,MATCH(A18,$A$17:$A$861,0),MATCH($ADG$1,$A$17:$ACX$17,0))=0,1,0)*(ADG2,$A$17:$ACX$17))>1,1,0))

 

Original data in cell below:

fjsh25_2-1634838453827.png

 

Any suggestions would be great. Thank you!

1 Reply

@fjsh25 

If reformat your second formula it looks as

=IF(
     INDEX( $A$17:$ACX$861,
            MATCH(A18,$A$17:$A$861,0),
            MATCH($ADG$1,$A$17:$ACX$17,0)
     ) = 0 ,
     1,
     0
    ) *
 (ADG2, $A$17:$ACX$17 ) ) > 1, 1, 0) )

here is more clear it has wrong syntax