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

MATCH perhaps

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JAH" wrote in message
ps.com...
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

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" wrote in message
ps.com...
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

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

Thank you

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

Change the formula to

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


--
Regards,

Peo Sjoblom



"JAH" wrote in message
oups.com...
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

Thanks everyone, I works!!

Jesse