#NAME? error

[Gibson P]

I would like to have the following
equation; =A(G5)
in Cell B7 instead of =A6. But I get the #NAME? error.
Cell G5 has the number 6 in it and Cell A6 has the
following text, "Test" in it. So I would expect B7 to have
the same value (i.e. "Test") but it displays #NAME?
instead. How can I do this?

 

[Peo Sjoblom]

One way

=INDIRECT("A"&G5)

 

[Chip Pearson]

Gibson,

Use something like the following:

=INDIRECT("A"&G5)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)