Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup issue | Excel Discussion (Misc queries) | |||
VLOOKUP issue | Excel Discussion (Misc queries) | |||
VLOOKUP ISSUE - Take II | Excel Worksheet Functions | |||
VLOOKUP ISSUE | Excel Worksheet Functions | |||
Vlookup issue | Excel Programming |