Using Named Cells

D

Dave

So I have named a cell "mortgage" which contains the results of a
mortgage calculation. I want to use the value elsewhere in my spread
sheet with something like the word "mortgage" as a label in cell A1
and the value, "=mortgage", in cell B1. However, it be cool if I could
reference the label in A1 for the formula in cell B1 and thereby NOT
have to type the label and the function, but just the label. Is there
a way to do this in excel?
 
J

JE McGimpsey

So I have named a cell "mortgage" which contains the results of a
mortgage calculation. I want to use the value elsewhere in my spread
sheet with something like the word "mortgage" as a label in cell A1
and the value, "=mortgage", in cell B1. However, it be cool if I could
reference the label in A1 for the formula in cell B1 and thereby NOT
have to type the label and the function, but just the label. Is there
a way to do this in excel?
Click to expand...


B1: =INDIRECT(A1)
 
Top