Referring to cells by range names

[rllane47]

thanks to everyone. here is the formula i was looking for:

=indirect(b1) indirect(a3)

or

=indirect("a") indirect("John")

quotes needed with range names, and two spaces in between the indirect

 

[RagDyer]

That Indirect containing the cell addresses needing 2 spaces is a new one on
me. ... TWO SPACES ? ! ? ! ?

As far as using the range names themselves, Indirect is *not* needed.

Have you tried simply:
=A<Space>John
?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


thanks to everyone. here is the formula i was looking for:

=indirect(b1) indirect(a3)

or

=indirect("a") indirect("John")

quotes needed with range names, and two spaces in between the indirect.

 

[Myrna Larson]

It DOESN'T require two spaces. 1 is sufficient.

 

[RagDyer]

You're right !

The first time I tried it ... it didn't.
I don't know what I did wrong.

Interesting though, that it works with any number of spaces.
--


Regards,

RD