+ Reply to Thread
Results 1 to 3 of 3

Data Validation with Indirect function referring to Offset named range = Error.

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    27

    Data Validation with Indirect function referring to Offset named range = Error.

    Hi,

    It will make a lot more sense if you see the file yourself, trust me. Please see attached.

    In the Fruit tab, in Row 2 and 3 is what I want my data to look like for all other rows.
    My problem is that the Data Validation in Column C doesn't seem to like an Indirect function that is referring to a named range that uses an Offset.

    What I want:
    Respectively, in Fruit C2, C3, my data validation refers to
    Please Login or Register  to view this content.
    However, Test_Apple/Test_Banana don't work for me because I will have over a dozen "Test_"'s. I need this to be more dynamic.

    My attempted solutions that give me errors:
    Respectively, in Fruit C4, C5, C6, my data validation refers to
    Please Login or Register  to view this content.
    Please help! I'm confuzzled.

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,621

    Re: Data Validation with Indirect function referring to Offset named range = Error.

    Seems to me that the problem is rather that the dynamic named ranges themselves do not work. Test the variables first by trying Goto or referencing them or something like that.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    06-03-2013
    Location
    Calcutta, India
    MS-Off Ver
    Excel 2010
    Posts
    1

    Erratic results while using the INDIRECT formula

    I have a spreadsheet where one column lists the high-level activities and another lists the sub-activities under each. To make the selection of the second dependent on the selection of the first I have used INDIRECT formula in the data validation. Out of 6 items in the first list, the results are perfectly fine for 5, but it is not working for one item (viz. self development). I am absolutely clueless. Kindly help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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