Is there any way to work around the limit of 29 arguments with the =CHOOSE function? I require probably 40 arguments when using it and could split it up, but it would just be a big hassle. Is there a similar function that doesn't have an argument limitation or is there a way to code around this?
I'm using Excel 2002.
Thanks for your help
Bookmarks