Multiple if then statements

[Closed]
Report
-
Hello,

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?