=INDEX('2008Summary'!$B14:$R14,,MATCH('Calc
Data'!B3,'2008Summary'!$B9:$R9,0))

or

=INDEX('2008Summary'!$B9:$R100,6,MATCH('Calc
Data'!B3,'2008Summary'!$B9:$R9,0))


where the 6 is the equivalent of the 5 in your offset formula
--


Regards,


Peo Sjoblom


"Dave F" wrote in message
ups.com...
Is there a more efficient/concise method for the following: =B8-
OFFSET(INDIRECT(CELL("address",INDEX('2008Summary' !
$B9:$R9,,MATCH('Calc Data'!B3,'2008Summary'!$B9:$R9,0)))),5,)

???

Dave