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 |
vlookup issue
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 |
All times are GMT +1. The time now is 05:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com