+ Reply to Thread
Results 1 to 3 of 3

data validation with indirect for more than 1 entry

  1. #1
    Registered User
    Join Date
    09-24-2010
    Location
    Victoria, BC
    MS-Off Ver
    Excel 2007
    Posts
    68

    data validation with indirect for more than 1 entry

    I am trying to arrange a dependent drop-down list and have the basic listing working. My problem however is that when i pull data from sheet "Mon" for column C using indirect it works but when I try to do the same thing for column D i get the same data as column C. How do i get indirect (or offset if it works better) to allow me to reference the alternate data 1 column over?
    If I helped, say thanks by clicking on the star.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,412

    Re: data validation with indirect for more than 1 entry

    It would help if you attached a sample workbook.

    Pete

  3. #3
    Registered User
    Join Date
    09-24-2010
    Location
    Victoria, BC
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: data validation with indirect for more than 1 entry

    Sorry, thought I had loaded the blank. Here it is.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-24-2010
    Location
    Victoria, BC
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: data validation with indirect for more than 1 entry

    Hoping someone out there can give me any form of hint on how to make this work.

    Thanx
    Last edited by Unca Wook; 08-15-2014 at 03:59 AM. Reason: did not post initially

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data validation using indirect
    By erisaaka in forum Excel General
    Replies: 1
    Last Post: 02-11-2014, 08:16 PM
  2. Replies: 4
    Last Post: 12-19-2013, 10:44 AM
  3. Indirect Data Validation
    By techteam in forum Excel General
    Replies: 3
    Last Post: 11-22-2011, 07:03 AM
  4. Replies: 0
    Last Post: 10-06-2011, 07:03 AM
  5. Data Validation with Indirect
    By Nigel in forum Excel General
    Replies: 3
    Last Post: 12-17-2005, 11:40 AM

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