a more efficient way of performing this calculation?

D

Dave F

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
 
P

Peo Sjoblom

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

defining an array for INDEX 1
VLookup using two criterias - looking for a efficient way 3
match true exact "dd" vs. find next 5th character=y 4
parsing a formula... 3
more efficient way to lookup a range? 1
Named Ranges & Calculation Times Query 5
Best way to pull data from several different sheets into a summary sheet 2
Would like a more efficient way to Copy/PasteSpecial 4

Top