ExcelBanter - a more efficient way of performing this calculation?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - a more efficient way of performing this calculation? (https://www.excelbanter.com/excel-discussion-misc-queries/160535-more-efficient-way-performing-calculation.html)

Dave F[_2_]

a more efficient way of performing this calculation?

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

Peo Sjoblom

a more efficient way of performing this calculation?

=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

All times are GMT +1. The time now is 01:50 AM.