Should it be Index or Offset ?

C

colwyn

=INDEX('2007'!A:N,K2,14)
=OFFSET('2007'!A1,K2-1,13)

Anyone know which of the above works fastest when applied down 50,000+
rows of several spreadsheets?
Thanks.
Colwyn.
 
B

Bob Phillips

INDEX

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
C

colwyn

Thanks Bob. Happened to get another answer also and it may help others
so will post it here. Colwyn.



"The OFFSET function is "volatile"....meaning that it recalculates
whenever any cell in the workbook calculates.

The INDEX function is non-volatile and only recalcs when one of it's
referenced values changes. Consequently, INDEX is faster.

The list of volatile functions includes:
RAND, NOW, TODAY, OFFSET, CELL, INDIRECT"
 
Top