Index formula with IF condition
 

I have got two matrixes that I need to use the index formula for, e.g if
criteria is X then use index formula on matrix one, if criteria is Y, then
use index formula on second matrix. I have tested them as stand alone
formula's and they work, but when I incorporate them if I type 6 in my
criteria, I get #VALUE and if i type 8 in my criteria, I get FALSE.

Where am I going wrong? Below is my formula:

=IF(E31<=7,INDEX($BD$21:$BJ$26,MATCH($N31,$BD$21:$ BD$26),MATCH($AU31,$BD$21:$BJ$21),IF(E317,INDEX($ BK$21:$BQ$26,MATCH($N31,$BK$21:$BK$26),MATCH($AU31 ,$BK$21:$BQ$21)))))

thanks for any help in advance!

Index formula with IF condition
 

Not sure, but maybe you should be using exact matches,
eg: MATCH(x,y:y,0)
ie with the zero param specified

You could also reconfig the IF simpler, indicatively like this:
=IF(E31<=7,index_match1,index_match2)
(The FALSE bit would probably go away if you did the above)
--
Max
Singapore
---
"Afsha" wrote:
I have got two matrixes that I need to use the index formula for, e.g if
criteria is X then use index formula on matrix one, if criteria is Y, then
use index formula on second matrix. I have tested them as stand alone
formula's and they work, but when I incorporate them if I type 6 in my
criteria, I get #VALUE and if i type 8 in my criteria, I get FALSE.

Where am I going wrong? Below is my formula:

=IF(E31<=7,INDEX($BD$21:$BJ$26,MATCH($N31,$BD$21:$ BD$26),MATCH($AU31,$BD$21:$BJ$21),IF(E317,INDEX($ BK$21:$BQ$26,MATCH($N31,$BK$21:$BK$26),MATCH($AU31 ,$BK$21:$BQ$21)))))

thanks for any help in advance!