How to have once cell equal a changin cell reference on another sh
 

I am trying to build a sheet that will reference a mortgage sheet in the same
document. I want to be able to see the remaining balance of a mortgage by
entering the number of years since the mortgage began.
What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10
would be the changing number of years since the mortgage began and the G cell
would be the remaining balance. So if it's 5 years since the mortgage began,
I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11.
Any ideas?
Thanks,
Nic

How to have once cell equal a changin cell reference on another sh
 

Try this:

=INDIRECT("G"&1+E10)

Hope this helps.

Pete

On Sep 19, 12:06 am, Nic wrote:
I am trying to build a sheet that will reference a mortgage sheet in the same
document. I want to be able to see the remaining balance of a mortgage by
entering the number of years since the mortgage began.
What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10
would be the changing number of years since the mortgage began and the G cell
would be the remaining balance. So if it's 5 years since the mortgage began,
I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11.
Any ideas?
Thanks,
Nic

How to have once cell equal a changin cell reference on another sh
 

INDIRECT is the missing link ..

Try it as: =INDIRECT("G"&(1+E10))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nic" wrote:
I am trying to build a sheet that will reference a mortgage sheet in the same
document. I want to be able to see the remaining balance of a mortgage by
entering the number of years since the mortgage began.
What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10
would be the changing number of years since the mortgage began and the G cell
would be the remaining balance. So if it's 5 years since the mortgage began,
I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11.
Any ideas?
Thanks,
Nic

How to have once cell equal a changin cell reference on anothe
 

Thanks Pete, fixed it right up!

Thought I might lose my hair figuring that out.

Nic

"Pete_UK" wrote:

Try this:

=INDIRECT("G"&1+E10)

Hope this helps.

Pete

On Sep 19, 12:06 am, Nic wrote:
I am trying to build a sheet that will reference a mortgage sheet in the same
document. I want to be able to see the remaining balance of a mortgage by
entering the number of years since the mortgage began.
What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10
would be the changing number of years since the mortgage began and the G cell
would be the remaining balance. So if it's 5 years since the mortgage began,
I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11.
Any ideas?
Thanks,
Nic

How to have once cell equal a changin cell reference on anothe
 

Thanks for feeding back, Nic - glad it worked for you.

Pete

On Sep 19, 12:26 am, Nic wrote:
Thanks Pete, fixed it right up!

Thought I might lose my hair figuring that out.

Nic



"Pete_UK" wrote:
Try this:

=INDIRECT("G"&1+E10)

Hope this helps.

Pete

On Sep 19, 12:06 am, Nic wrote:
I am trying to build a sheet that will reference a mortgage sheet in the same
document. I want to be able to see the remaining balance of a mortgage by
entering the number of years since the mortgage began.
What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10
would be the changing number of years since the mortgage began and the G cell
would be the remaining balance. So if it's 5 years since the mortgage began,
I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11.
Any ideas?
Thanks,
Nic- Hide quoted text -

- Show quoted text -

How to have once cell equal a changin cell reference on another sh
 

One mo
=index(g:g,1+e10)


Nic wrote:

I am trying to build a sheet that will reference a mortgage sheet in the same
document. I want to be able to see the remaining balance of a mortgage by
entering the number of years since the mortgage began.
What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10
would be the changing number of years since the mortgage began and the G cell
would be the remaining balance. So if it's 5 years since the mortgage began,
I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11.
Any ideas?
Thanks,
Nic

--

Dave Peterson