I created a scrolling table (form control) that uses the offset function to show a portion of a large amount of data. I'm sure you gurus know a better way, but my issue is I have 5 different arrays of data I'd like to be able to show based on a selection from a combo box but get a "You've entered too many arguments" error when trying to add more "IF's" to my current formula below. Ultimately, what is the best way to use the (0,1,2,3,4,5) the combo box will give me to reference 5 unique tables for my scrolling table?
IF($M$1=1,OFFSET(Data!A573,$M$2,0),IF($M$1=2,OFFSET(Data!J573,$M$2,0).....$M$1 is my combo box.
Thanks,
Bookmarks