Current Mortgage Balance

[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

 

[Don Guillett]

MATCH perhaps

 

[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

 

[JAH]

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

Thank you

 

[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

 

[Peo Sjoblom]

Change the formula to

=VLOOKUP(TODAY(),'Mortgage Sheet 1'!A:F,6)

 

[JAH]

Thanks everyone, I works!!

Jesse