A
Afsha
I am trying to use the index formula but need to incorporate an IF condition.
For some reason, the formula does not seem to be picking up the second IF
condition.
I am trying to say if the number is cell X is more than 7 then use the first
matrix, if the number is less than 8 then use the second matrix.... below is
a copy of the formula, can someone tel me where I am going wrong?
=IF(E31>7,(INDEX($BD$21:$BJ$26,MATCH($N31,$BD$21:$BD$26),MATCH($AU31,$BD$21:$BJ$21),IF(E31<8,(INDEX($BK$21:$BQ$26,MATCH($N31,$BK$21:$BK$26),MATCH($AU31,$BK$21:$BQ$21)))))))
thanks
For some reason, the formula does not seem to be picking up the second IF
condition.
I am trying to say if the number is cell X is more than 7 then use the first
matrix, if the number is less than 8 then use the second matrix.... below is
a copy of the formula, can someone tel me where I am going wrong?
=IF(E31>7,(INDEX($BD$21:$BJ$26,MATCH($N31,$BD$21:$BD$26),MATCH($AU31,$BD$21:$BJ$21),IF(E31<8,(INDEX($BK$21:$BQ$26,MATCH($N31,$BK$21:$BK$26),MATCH($AU31,$BK$21:$BQ$21)))))))
thanks