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