I have a multi-sheet (3-D) range name specifying
(the same) column for all my sheets:
wbFY_2007 is defined as sheet1:sheet3!$G:$G
I have another range name specifying a row on the third
AMT is defined as sheet3!$36:$36
I thought that the intersection operator would make an
intersection between the multisheet range and the single
sheet range, and come up with the AMT on sheet3 in column
The formula used was =(wbFY_2007 AMT), and the result produced
Question: is it possible to "intersect" a multisheet (3-D)
range (specifying the same column on all the sheets) with a
single sheet range (specifying a row on one of the sheets)?
And if so, then how does one go about doing it.