Current Mortgage Balance

J

JAH

Hello.

I have created a spreadsheet that lists the "current" balances of all
our mortgages. By using seperate worksheets containing each mortgages
amortization schedule, I would like to pull the "current" balance of
each mortgage onto the summary sheet. Is there any way to do this?

Example:

Todays date is July 24, 2007. The summary sheet would display the
cell containing the balance of the mortgage after the July 1, 2007
payment. This amount would be on the seperate amortization worksheet
for that loan.

Thanks in advance for any help.

JH
 
B

Bernie Deitrick

JH,

Use a VLOOKUP function, like

=VLOOKUP(TODAY(),'Mortgage Sheet 1'!A:B,2)

where dates are in column A and balances in column B...

HTH,
Bernie
MS Excel MVP
 
J

JAH

Can you provide any more information on the MATCH function and how I
could implement it in this situation?

Thank you
 
J

JAH

Bernie,

Thanks. I almost have it working, only I cannot get it to pull the
balance from column F instead of B. It only seems to work in column
B. Any ideas?

Jesse
 

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


Top