Thread: vlookup issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lolly[_2_] Lolly[_2_] is offline
external usenet poster
 
Posts: 28
Default 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