I keep a register (like in a check book) on excel on my home PC because it is really convenient when doing online banking. I have a worksheet for both my checking accounts, a few other assets i like to keep track of, and i have a budget sheet. I use formulas everywhere to do the math for me and I would like to reference the ending balance of my two checking accounts to my budget worksheet. I have tried =vlookup and i have tried =Mainaccout!D112 and both return a value of $0 no matter what the total is. I have even tried referencing a cell that does not have a formula within it and get the same value. Help?
Microsoft Win XP SP 3
Microsoft Excel 2002
