+ Reply to Thread
Results 1 to 4 of 4

Using Indirect function to return a named range.

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    home
    MS-Off Ver
    Excel 2003
    Posts
    26

    Using Indirect function to return a named range.

    Hi there,

    I'm trying to create an index function to return values from Tab1, based on a drop down list on Tab2. The result should be returned to cell d6 on Tab3 but I'm not able to build the indirect function in a workable manner.

    Tab3D6 is basically reading information on Tab2A1, and building a query to search the named range (Tab1Table1) on Tab1.

    Not sure if you guys get it, but once you look at Tab3D6 you'll understand what I'm trying to do.


    Any help appreciated.

    indirect function.xlsx

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Using Indirect function to return a named range.

    Hi adrianodl,

    you can use the below formula to correct the reference in Indirect function :-

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    I am not sure how and from where you wish to provid erow and column indexes.. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    08-17-2012
    Location
    home
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Using Indirect function to return a named range.

    Hi Dili,
    Unfortunately this solution didn't work. It's not pointing to my named range.

    What I'm having issues with is that the following formula:
    Please Login or Register  to view this content.
    is resolving the indirect as Tab2!A1 but not bringing the actual content of cell Tab2!A1 (Tab1).
    The working formula should resolve to something like:
    Please Login or Register  to view this content.
    Does it make sense?

    Cheers!
    ADri

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Using Indirect function to return a named range.

    Hi ADri..

    In my earlier reply, I igonred the defnied names...
    Ok.. so in your formula syntax " Tab1!Tab1Table1" which one is the defined name.. I believe in Index you should provide first the Array / reference ... suggest you to do it first without defined names and check if that works and then convert that worked reference in the defined name and use with Index function. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ 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