![]()
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?
Bookmarks