Display a cell value by another cell
 

I already posted this, but I think I may have inadvertently posted it to the
wrong area. I have made an amortization table to figure payoffs. I have
already made the table, it figures the amoritization, the payments, number of
days to first payment, the per diem, and the payoff as of that date. I am
displaying the payoff figures in a row. I would like to create a cell that
has the number of months past that will bring up the figure from the row.
Example: If the months past were 5 and the row started on line a10, the
figure I would be looking for would be on line a15, if it were 7months past
the figure I would want displayed in a seperate cell would be on line a17.

Thanks,

Mark.

Display a cell value by another cell
 

Not sure I understand but maybe:

=INDIRECT("A"&10+DATEDIF(B1,TODAY(),"m"))

where B1 is a start date
A is the column with values to return and 10 is the starting row

HTH
JG

"STARFINANCIALGROUP" wrote:

I already posted this, but I think I may have inadvertently posted it to the
wrong area. I have made an amortization table to figure payoffs. I have
already made the table, it figures the amoritization, the payments, number of
days to first payment, the per diem, and the payoff as of that date. I am
displaying the payoff figures in a row. I would like to create a cell that
has the number of months past that will bring up the figure from the row.
Example: If the months past were 5 and the row started on line a10, the
figure I would be looking for would be on line a15, if it were 7months past
the figure I would want displayed in a seperate cell would be on line a17.

Thanks,

Mark.

Display a cell value by another cell
 

Or

=INDEX(A10:A20,DATEDIF(G1,TODAY(),"m"),0)

HTH
JG

"STARFINANCIALGROUP" wrote:

I already posted this, but I think I may have inadvertently posted it to the
wrong area. I have made an amortization table to figure payoffs. I have
already made the table, it figures the amoritization, the payments, number of
days to first payment, the per diem, and the payoff as of that date. I am
displaying the payoff figures in a row. I would like to create a cell that
has the number of months past that will bring up the figure from the row.
Example: If the months past were 5 and the row started on line a10, the
figure I would be looking for would be on line a15, if it were 7months past
the figure I would want displayed in a seperate cell would be on line a17.

Thanks,

Mark.

Display a cell value by another cell
 

Thank you so much for your help, I can't seem to get either of these to work
in my current situation. To explain more of what I am trying to accomplish.
Imagine if I were to make an excel sheet that was like a multiple choise
question. Answer 1 is in cell a1 and is 500 and is simply called 1, a2 is
1000 and is called 2, a3 is 1500 and is called 3. In a4 I select my response
as 2, so in cell a5 my answer would appear as 1000. In my problem I am
trying to select a value based on the cell that it is in, and be able to name
the cell a different, more recognized name than one in an excel application.

Again, Thanks for your help.

Mark.
"pinmaster" wrote:

Not sure I understand but maybe:

=INDIRECT("A"&10+DATEDIF(B1,TODAY(),"m"))

where B1 is a start date
A is the column with values to return and 10 is the starting row

HTH
JG

"STARFINANCIALGROUP" wrote:

I already posted this, but I think I may have inadvertently posted it to the
wrong area. I have made an amortization table to figure payoffs. I have
already made the table, it figures the amoritization, the payments, number of
days to first payment, the per diem, and the payoff as of that date. I am
displaying the payoff figures in a row. I would like to create a cell that
has the number of months past that will bring up the figure from the row.
Example: If the months past were 5 and the row started on line a10, the
figure I would be looking for would be on line a15, if it were 7months past
the figure I would want displayed in a seperate cell would be on line a17.

Thanks,

Mark.

Display a cell value by another cell
 

Using your example, type this in A5

=INDEX(A1:A3,A4,0)
or
=IF(A4="","",INDEX(A1:A3,A4,0))
now type 1, 2 or 3 in A4

Does that help?
JG

"STARFINANCIALGROUP" wrote:


Thank you so much for your help, I can't seem to get either of these to work
in my current situation. To explain more of what I am trying to accomplish.
Imagine if I were to make an excel sheet that was like a multiple choise
question. Answer 1 is in cell a1 and is 500 and is simply called 1, a2 is
1000 and is called 2, a3 is 1500 and is called 3. In a4 I select my response
as 2, so in cell a5 my answer would appear as 1000. In my problem I am
trying to select a value based on the cell that it is in, and be able to name
the cell a different, more recognized name than one in an excel application.

Again, Thanks for your help.

Mark.
"pinmaster" wrote:

Not sure I understand but maybe:

=INDIRECT("A"&10+DATEDIF(B1,TODAY(),"m"))

where B1 is a start date
A is the column with values to return and 10 is the starting row

HTH
JG

"STARFINANCIALGROUP" wrote:

I already posted this, but I think I may have inadvertently posted it to the
wrong area. I have made an amortization table to figure payoffs. I have
already made the table, it figures the amoritization, the payments, number of
days to first payment, the per diem, and the payoff as of that date. I am
displaying the payoff figures in a row. I would like to create a cell that
has the number of months past that will bring up the figure from the row.
Example: If the months past were 5 and the row started on line a10, the
figure I would be looking for would be on line a15, if it were 7months past
the figure I would want displayed in a seperate cell would be on line a17.

Thanks,

Mark.

Thanks, you saved my sanity!
 

Thanks, you saved my sanity!

Mark
"pinmaster" wrote:

Using your example, type this in A5

=INDEX(A1:A3,A4,0)
or
=IF(A4="","",INDEX(A1:A3,A4,0))
now type 1, 2 or 3 in A4

Does that help?
JG

"STARFINANCIALGROUP" wrote:


Thank you so much for your help, I can't seem to get either of these to work
in my current situation. To explain more of what I am trying to accomplish.
Imagine if I were to make an excel sheet that was like a multiple choise
question. Answer 1 is in cell a1 and is 500 and is simply called 1, a2 is
1000 and is called 2, a3 is 1500 and is called 3. In a4 I select my response
as 2, so in cell a5 my answer would appear as 1000. In my problem I am
trying to select a value based on the cell that it is in, and be able to name
the cell a different, more recognized name than one in an excel application.

Again, Thanks for your help.

Mark.
"pinmaster" wrote:

Not sure I understand but maybe:

=INDIRECT("A"&10+DATEDIF(B1,TODAY(),"m"))

where B1 is a start date
A is the column with values to return and 10 is the starting row

HTH
JG

"STARFINANCIALGROUP" wrote:

I already posted this, but I think I may have inadvertently posted it to the
wrong area. I have made an amortization table to figure payoffs. I have
already made the table, it figures the amoritization, the payments, number of
days to first payment, the per diem, and the payoff as of that date. I am
displaying the payoff figures in a row. I would like to create a cell that
has the number of months past that will bring up the figure from the row.
Example: If the months past were 5 and the row started on line a10, the
figure I would be looking for would be on line a15, if it were 7months past
the figure I would want displayed in a seperate cell would be on line a17.

Thanks,

Mark.

Thanks, you saved my sanity!
 

You're welcome and thanks for the feedback!

Regards
Jean-Guy

"STARFINANCIALGROUP" wrote:


Thanks, you saved my sanity!

Mark
"pinmaster" wrote:

Using your example, type this in A5

=INDEX(A1:A3,A4,0)
or
=IF(A4="","",INDEX(A1:A3,A4,0))
now type 1, 2 or 3 in A4

Does that help?
JG

"STARFINANCIALGROUP" wrote:


Thank you so much for your help, I can't seem to get either of these to work
in my current situation. To explain more of what I am trying to accomplish.
Imagine if I were to make an excel sheet that was like a multiple choise
question. Answer 1 is in cell a1 and is 500 and is simply called 1, a2 is
1000 and is called 2, a3 is 1500 and is called 3. In a4 I select my response
as 2, so in cell a5 my answer would appear as 1000. In my problem I am
trying to select a value based on the cell that it is in, and be able to name
the cell a different, more recognized name than one in an excel application.

Again, Thanks for your help.

Mark.
"pinmaster" wrote:

Not sure I understand but maybe:

=INDIRECT("A"&10+DATEDIF(B1,TODAY(),"m"))

where B1 is a start date
A is the column with values to return and 10 is the starting row

HTH
JG

"STARFINANCIALGROUP" wrote:

I already posted this, but I think I may have inadvertently posted it to the
wrong area. I have made an amortization table to figure payoffs. I have
already made the table, it figures the amoritization, the payments, number of
days to first payment, the per diem, and the payoff as of that date. I am
displaying the payoff figures in a row. I would like to create a cell that
has the number of months past that will bring up the figure from the row.
Example: If the months past were 5 and the row started on line a10, the
figure I would be looking for would be on line a15, if it were 7months past
the figure I would want displayed in a seperate cell would be on line a17.

Thanks,

Mark.