Multiple if then statements

ax837077 - Aug 27, 2016 at 04:08 PM

i am trying to write a ridiculous amount of if then statements (100+). i can nest them on a single worksheet no problem, however, trying to transfer multiple lines to a single cell on a different worksheet is proving too much for me.

I have also tried the choose function, but again i am limited to 30 or so.

what function should i use and how should i use it?