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.