vlookup issue
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
--
Kittie
|