Should it be Index or Offset ?
 

=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.

Should it be Index or Offset ?
 

INDEX

--
HTH

Bob

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

"colwyn" wrote in message
...

=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.

Should it be Index or Offset ?
 

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"