View "name" in cell

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi,

I am using the "name" function from the INSERT menu.

eg. Monday=Sheet1!$C$11, whose value is 24.

When I type

=Monday

in a cell, this returns the value 24 as expected.

What I would like to see is the actual "name" in the cell
(ie. "Monday") rather than the value, but still be able
to use the value in later calculations.

Is this possible or am I expecting a little too much?

Thnanks in anticipation of your help out there...

Mike
 
Mike,

As I understand your question, the answer is that it can't be
done.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
I'm not sure if this is what you mean, but if you type: Monday in a different
cell (say A1), you can get the value 24 by:

=indirect(a1)
 
Back
Top