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