Look at Charles' site

http://www.decisionmodels.com

he has hints on using Vlookup and such to optimize speed.

--
Regards,
Tom Ogilvy

"Lolly" wrote in message
...
I am trying to copy data from one sheet to another. The formula which I am
using is
=IF(NOT(ISNUMBER(vlookup($A12,

sheet2!$A1:$FZ70,5,FALSE))),"",(ISNUMBER(vlookup($ A12,sheet2!$A1:$FZ70,5,FAL
SE)))

I have lots of data so I need to use this range. When I am using this
formula. It takes lot of time for excel sheet to come up with data
populated
in sheet1. Could any body help me in that.

Col index number goes like this 5,8,11,13 nad so on (adding 3 to previous
one) ina a row in excel sheet

Any help would be greatly appreciated.

Regards
kittie
--
Kittie