Index formula with IF condition

A

Afsha

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(E31>7,INDEX($BK$21:$BQ$26,MATCH($N31,$BK$21:$BK$26),MATCH($AU31,$BK$21:$BQ$21)))))

thanks for any help in advance!
 
M

Max

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top