How do I get the value of a label to be displayed in Excel?
I figured it was something simple, just couldnt find it in the help files.
Thanks Niek and Marcelo!
"Marcelo" wrote:
If I understand correctly, you have named a cell as tax on A1
if you have Tax on B5
Enter on B6 the funcion =INDIRECT(B5)
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"NickR2" escreveu:
I would like to have a cell display the Value of a NAME, when the NAME is
entered in an adjacent cell. For example, if the NAME "Tax" = A1, which has a
6 entered into it, when you enter TAX in b5, the value of "6" will appear in
b6.
If I place the NAME in the Formula, ie: =TAX, then it displays 6, BUT, if
the Formula in b6 is: =b5 it displays "TAX", not it's value. The
application I am creating is a code translator, where one enters a letter of
the alphabet, and the associated code for that letter is displayed. It's a
simple character substitution, using A=3; B=4; ... y=+ etc. I have
created a list of NAMES, assigning the cells with the assocaited code to each
letter, which has been defined as a name.
|