Last post was in relation to using the range names themselves in a formula.
To rllane47,
Suggest that you rename some of your ranges and retry using the names
*without* the necessity of incorporating them in an Indirect formula.
=Tom Joe
For example works on all the three platforms and versions that I tested.
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------
It is not clear to me what you tried, what did work and what didn't.
I tested my answer:
----------
=INDIRECT(Q5) INDIRECT(T3)
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.
