Intersection of named ranges

J

Jimper

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there some way to refer to a cell where two named ranges intersect? For example, if Column B is "Jan_1" and Row 12 is "SumTotal", can one refer to cell B12 in terms of the two named ranges?

MTIA!
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

Is there some way to refer to a cell where two named ranges intersect? For
example, if Column B is "Jan_1" and Row 12 is "SumTotal",
can one refer to cell B12 in terms of the two named ranges? <br><br>MTIA!
Click to expand...

One way:

=Jan_1 SumTotal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

breaking text into multiple cells 5
Chart Tab Names 0
excel 2008 for Mac from a lifetime PC Microsoft Excel user convert 1
Question mark on Excel 2008 in Dock 1
Conditional formatting by number of characters in cell 2
Using COUNTIF but blank cell if zero 3
"Add data" to chart menu command won't work 0
Help menu malfunction 3

Top