Named range of Named ranges

**georgedixon** · 09-16-2017, 06:43 PM

Hi,
I was wondering if it is possible to make a named range, that is a combination of other named ranges.
For example, if i made one called "ONE" and this included the named range "TWO" and "THREE" where two and three contain some cell range. Could i then use this range within a vlookup or similar function so that it searches both ranges. Thanks

**jeffreybrown** · 09-16-2017, 06:47 PM

If this question is related to this thread, then why not post a sample and a CLEAR example in the other thread. Please don't post a broken solution, post the example data and what you expect as an answer.

Also, does this thread mean you don't want to complete your other thread?

Named range of Named ranges

LinkBack

Thread Tools

Rate This Thread

Display

Named range of Named ranges

Re: Named range of Named ranges

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Combine all Named Ranges into one Named Range

Copy values of all named range in wb1 to identically named ranges in wb2

Looping Mutliple Named Resized Ranges in next empty row below another named range

[SOLVED] Determining if the value of a cell can be a named range, then assigning named ranges after

I have 2 named ranges on 1 sheet and 1 named range on another..

Named ranges-Should I use a dynamic named range

Named ranges-is there a an easy way to reference a single value in a named range?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions