Does this work for you:
=SUM([asite_162.xls]Bud!$B$16:INDEX([asite_162.xls]Bud!$B$16:$M$16,VLOOKUP(L
EFT($B$1,3),Sheet2!$B$3:$C$14,2,0)))
?
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Monte75" wrote in
message ...
I am using an OFFSET() combined with a VLOOKUP() function in the formula
below to allow me to pluck budget information from a 12 month budget.
The OFFSET() allows me to specify a month (in $B$1) and get the budget
through that month. I am pulling from many different files.
=SUM(OFFSET([asite_162.xls]Bud!$B$12:$M$60,4,0,1,VLOOKUP(LEFT($B$1,3),Sheet2
!$B$3:$C$14,2,FALSE)))
My problem is that I get a #VALUE! error when I don't have the other
workbooks open. I know that this is because the formula is volatile.
Is there a way for me to tell the formula to remember the last data
instead of defaulting to an error? Is there some other workaround? I
am using Excel 2003
--
Monte75
------------------------------------------------------------------------
Monte75's Profile:
http://www.excelforum.com/member.php...fo&userid=2171
View this thread: http://www.excelforum.com/showthread...hreadid=472789