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(E317,(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($AU3 1,$BK$21:$BQ$21)))))))

thanks