Results 1 to 17 of 17

Super cool named ranges with offset.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-17-2010
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    127

    Super cool named ranges with offset.

    I have named ranges : bd, pl, wh.

    Can anyone make a function that calls up multiple cells from those ranges like so:

    =FUNCTIONNAME(bd3,pl1,wh5)
    That would return the same thing as =INDEX(bd,3)&INDEX(pl,1)&INDEX(wh,5)
    (i can guarantee that the ranges would never have numbers in their names)

    if you need another separator you could use space or "." or "-" or ";" (space would be awesome)

    =FUNCTIONNAME(bd 3,pl 1,wh 5)
    =FUNCTIONNAME(bd.3,pl.1,wh.5)
    =FUNCTIONNAME(bd-3,pl-1,wh-5)
    =FUNCTIONNAME(bd;3,pl;1,wh;5)

    THREAD IS SOLVED with two cool solutions:
    Anyone who uses named ranges could benefit from these.

    EXAMPLE IN ATTACHMENT:
    Attached Files Attached Files
    Last edited by Polymorpher; 08-01-2014 at 09:20 AM. Reason: Solved, proper search name.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Define only 2 named ranges from a list of named ranges...
    By abhi900 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2014, 04:20 AM
  2. Looping Mutliple Named Resized Ranges in next empty row below another named range
    By gingumdog in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2014, 08:15 PM
  3. Can someone tweak a small vba code for me?
    By boniouk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2013, 07:35 AM
  4. [SOLVED] Determining if the value of a cell can be a named range, then assigning named ranges after
    By Romulo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-15-2013, 06:05 PM
  5. Replies: 1
    Last Post: 03-21-2006, 06:40 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