+ Reply to Thread
Results 1 to 2 of 2

Scrolling Table display different arrays based on change to validation cell formula help

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    St. Louis, MO
    MS-Off Ver
    Excel 2003
    Posts
    23

    Scrolling Table display different arrays based on change to validation cell formula help

    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,
    Last edited by jrvstl; 08-02-2012 at 05:03 PM. Reason: figured it out

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Scrolling Table display different arrays based on change to validation cell formula he

    jrvstl,

    Its great that you figured out the solution to your question by yourself.

    However, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1