Display a cell value by another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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
 
Thanks, you saved my sanity!

Mark
pinmaster said:
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
Click to expand...
 

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

Picking a cell to show in another page. 2
Display a cell as 0 if cell it is copying has no value 3
Lookup, Index or Offset 1
how do i calculate a running payoff amount? 2
Adding cells by 2 criteria that move. 1
How do I get a formula to calculate the third Thursday of the mont 7
Internet amortization answers differ from function 5
Panic at the PC - Need Excel spreadsheet help! 9

Back
Top