#NAME? error

  • Thread starter Thread starter Gibson P
  • Start date Start date
G

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?
 
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)
 
Back
Top