Combining Multiple Statements That Multiple if Statements

[OregonMBA]

I am trying to combine the below formulas into one formula. I have already tested each one to make sure they work independently. I keep getting an error when I try to combine them.

Any help is appreciated.


=IF(E2=Quartiles!$E$2,IF('2010-2019 Compiled'!I2>=Quartiles!E$6,"Tall",IF('2010-2019 Compiled'!I2>=Quartiles!E$4,"Average",IF('2010-2019 Compiled'!I2>=Quartiles!E$3,"Short"))))

=IF(E2=Quartiles!$F$2,IF('2010-2019 Compiled'!I2>=Quartiles!F$6,"Tall",IF('2010-2019 Compiled'!I2>=Quartiles!F$4,"Average",IF('2010-2019 Compiled'!I2>=Quartiles!F$3,"Short"))))

=IF(E2=Quartiles!$G$2,IF('2010-2019 Compiled'!I2>=Quartiles!G$6,"Tall",IF('2010-2019 Compiled'!I2>=Quartiles!G$4,"Average",IF('2010-2019 Compiled'!I2>=Quartiles!G$3,"Short"))))

=IF(E2=Quartiles!$H$2,IF('2010-2019 Compiled'!I2>=Quartiles!H$6,"Tall",IF('2010-2019 Compiled'!I2>=Quartiles!H$4,"Average",IF('2010-2019 Compiled'!I2>=Quartiles!H$3,"Short"))))

=IF(E2=Quartiles!$I$2,IF('2010-2019 Compiled'!I2>=Quartiles!I$6,"Tall",IF('2010-2019 Compiled'!I2>=Quartiles!I$4,"Average",IF('2010-2019 Compiled'!I2>=Quartiles!I$3,"Short"))))

[Ron Coderre]

Based on the limited information you provided, I think something like this formula will work for you:

Please Login or Register  to view this content.

It's not pretty, but is it something you can work with?

[OregonMBA]

I was able to get some help and learned that I could get desired result using the SWITCH function.

Thank you.

[mehmetcik]

=IF('2010-2019 Compiled'!I2>=OFFSET(Quartiles!D$6,0,MATCH(E2,Quartiles!E2:I2,0)),"Tall",IF('2010-2019 Compiled'!I2>=OFFSET(Quartiles!D$4,0,MATCH(E2,Quartiles!E2:I2,0)),"Average","Short"))