Results 1 to 3 of 3

Excel 2007 : Dependent Validation on seperate worksheets - array not working

Threaded View

  1. #1
    Registered User
    Join Date
    09-02-2011
    Location
    Yate, South Glos.
    MS-Off Ver
    Excel 2007
    Posts
    23

    Smile Dependent Validation on seperate worksheets - array not working

    This forum briliantly helped me set up dependent data validation on seperate sheets in a workbook .
    I have used these to construct my question sets, but on testing, I find that for some reason, the look up array for certain lines is looking at the wrong array.
    I can't for the life of me see any difference in my formula, and have checked the arrays for any spurious or illegal characters or formatting.
    The validatin lists and arrays are on sheet one of the attached.
    The testing page is on "Team 1" worksheet, along with a note as to the error
    Can anyone tell me where I am going wrong please ?
    Thanks so much in advance.
    Attached Files Attached Files
    Last edited by MariaBryan; 09-26-2011 at 06:31 AM.

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