Forum Discussion
IF/AND formula with an index match.
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 i...
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