vlookup issue

[Guest]

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,FALSE)))

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

 

[Tom Ogilvy]

Look at Charles' site

http://www.decisionmodels.com

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