Results 1 to 12 of 12

Index a Named Range

Threaded View

  1. #1
    Forum Contributor her.rockstar's Avatar
    Join Date
    01-11-2013
    Location
    Saint John, NB
    MS-Off Ver
    Office 365
    Posts
    194

    Index a Named Range

    Hello, I have a worksheet (Variables) in my workbook with 73 dynamic named ranges.
    On my Entry sheet, I need to find a way to index a named range of my choosing.

    For example,
    I will choose a named range from a drop-down

    VARarea

    Then below, I need to list the 10 (or however many) items resulting from that named range

    I understand I can go
    =index(VARarea,1)
    which will bring me the first result, and then I could use 2 the line below, etc., but I need to be able to dynamically change the VARarea to something else. Using a cell reference doesn't work though. Seems like I need INDIRECT?
    Last edited by her.rockstar; 07-05-2018 at 09:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUM part of named range with INDEX
    By esbencito in forum Excel General
    Replies: 4
    Last Post: 04-19-2018, 07:12 AM
  2. Named range in Index & Match
    By edward_glyver in forum Excel General
    Replies: 10
    Last Post: 04-29-2016, 08:11 AM
  3. [SOLVED] =AVERAGEIF with named range index
    By Nate Westcott in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-03-2015, 12:42 PM
  4. Help using named range with index function
    By mpjennings25 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-08-2013, 04:09 PM
  5. Help using named range with index function
    By mpjennings25 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-08-2013, 03:48 PM
  6. Using INDEX with named range reference
    By engmeee in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 11-19-2008, 06:21 PM
  7. Named range lookup using Index and match
    By Sirrob01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-01-2007, 11:15 PM

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