Nesting IF's Limit

[Emma_]

Dear Forum, I am categorizing my different business units based on net sales. I have set different criterias depending on the business unit name and 3 sale intervalls. Now I get an error that I cannot add another IF function for my last business unit. So, my question is if I somehow can shorten this down so that I can include my last "BU6" with its criterias. I really don't see how I could do this. Would it somehow be possible? Appreciate any help, thank you! =IF(N19="BU1";IF(W19>=2000000;"1";IF(AND(W19>=900000;W19<=1999999);"2";IF(W19<=899999;"3")));IF(N19="BU2";IF(W19>=3000000;"1";IF(AND(W19>=1500000;W19<=2999999);"2";IF(W19<=1499999;"3")));IF(N19="BU3";IF(W19>=300000;"1";IF(AND(W19>=100000;W19<=299999);"2";IF(W19<=99999;"3")));IF(N19="BU4";IF(W19>=400000;"1";IF(AND(W19>=200000;W19<=399999);"2";IF(W19<=199999;"3")));IF(N19="BU5";IF(W19>=300000;"1";IF(AND(W19>=150000;W19<=299999);"2";IF(W19<=149999;"3"))))))))

 

[Andrew Poulsom]

Welcome to MrExcel.

Use a lookup table:

http://www.contextures.com/xlFunctions02.html

 

[Emma_]

Dear Andrew, What would my lookup table look like if I had the following condition for the intervals: 1= >2000000, 2= 2000000-900000, 3= <900000?

 

[Emma_]

Hold on, think I got it