If Statement Limits

Is there a way around the 7 IF statements in a formula? I have a formula that works but crashes if I go past this limit. I need a formual that would do up to 15 IF statements. Here is an example:

=IF(RC15=36,INDEX('Bath Tissue'!R3C1:R12C15,MATCH('DVoid Import Sheet'!RC9,'Bath Tissue'!R3C1:R12C1,0),4),IF(RC15=32,INDEX('Bath Tissue'!R3C1:R12C18,MATCH('DVoid Import Sheet'!RC9,'Bath Tissue'!R3C1:R12C1,0),5),IF(RC15=28,INDEX('Bath Tissue'!R3C1:R12C18,MATCH('DVoid Import Sheet'!RC9,'Bath Tissue'!R3C1:R12C1,0),6),IF(RC15=24,INDEX('Bath Tissue'!R3C1:R12C18,MATCH('DVoid Import Sheet'!RC9,'Bath Tissue'!R3C1:R12C1,0),7),IF(RC15=20,INDEX('Bath Tissue'!R3C1:R12C18,MATCH('DVoid Import Sheet'!RC9,'Bath Tissue'!R3C1:R12C1,0),8),"")))))

Is there a way around this?

Try the following...

=INDEX('Bath Tissue'!R3C1:R12C18,MATCH('DVoid Import Sheet'!RC9,'Bath Tissue'!R3C1:R12C1,0),CHOOSE(MATCH(RC15,{36,32,28,24,20},0),4,5,6,7,8))

OR

=INDEX('Bath Tissue'!R3C1:R12C18,MATCH('DVoid Import Sheet'!RC9,'Bath Tissue'!R3C1:R12C1,0),VLOOKUP(RC15,Sheet3!R1C1:R5C2,2,0))

...where Sheet3!R1C1:R5C2 contains the following table:

Please Login or Register  to view this content.

I'm assuming that the reference for the first INDEX function should be R12C18 not R12C15.

Hope this helps!