P
pgarcia
Hello all,
Can you add a ISNA in a index match formula? I try to put it in the formula
but it did not like it.
{=INDEX('101408'!$T$2:$T$2491,MATCH(1,(M2='101408'!$R$2:$R$2491)*(I2='101408'!$S$2:$S$2491),0))}
Thanks
Can you add a ISNA in a index match formula? I try to put it in the formula
but it did not like it.
{=INDEX('101408'!$T$2:$T$2491,MATCH(1,(M2='101408'!$R$2:$R$2491)*(I2='101408'!$S$2:$S$2491),0))}
Thanks