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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
VBA Coding Help for Beginner 0
ASK Field Formatting 1
If, Or, and 5
Cell data entering slow! 0
Display weeks from a Milestone 0
Using Filters with BCM Contacts 0
Word macro that can call cells out of Excel for a find and replace 0

Top