using intersection of ranges

[boris]

Need to specify the intersection of two named ranges, but
require either one or both of them to be referenced to
other cells. In other words, someone would enter the
range which is one or both of the two, and I need the
formula to look at that cell and use its name in the
intersection argument.

Any ideas? I have tried TEXT, but that doesn't seem to do
it.

 

[Niek Otten]

Suppose the rangenames are rangeA and rangeB, and the names are in D2 and D3

=INDIRECT(D2) INDIRECT(D3)

Note the spaces between the two functions; space is the intersection
operator.

Now you'll have to test for one or two names, but I suppose the essentials
of the method are clear.