View "name" in cell

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
 
D

Dave Peterson

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