Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative of Vlookup function which improves speed
I have my data table in one sheet named "CODE" and lookup value table named
"INDEX" in another. I have this formula =IF(A4="","",VLOOKUP(A4,INDEX!$A$3:$C$1872,3,FALSE )) which runs down to 19000 in sheet "CODE". It takes a lot of time to recalcualte/save. I think the vlookup is causing the workbook to slow down. What function could be used instead of vlookup to improve the calculation speed. Please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative of Vlookup function which improves speed
Take a look this site:
http://www.decisionmodels.com/optspeedb.htm "shabutt" wrote: I have my data table in one sheet named "CODE" and lookup value table named "INDEX" in another. I have this formula =IF(A4="","",VLOOKUP(A4,INDEX!$A$3:$C$1872,3,FALSE )) which runs down to 19000 in sheet "CODE". It takes a lot of time to recalcualte/save. I think the vlookup is causing the workbook to slow down. What function could be used instead of vlookup to improve the calculation speed. Please help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative of Vlookup function which improves speed
Hi,
Here are three Microsoft sites addressing this topic: http://support.microsoft.com/kb/825012 http://msdn.microsoft.com/en-us/libr...ffice.10).aspx http://support.microsoft.com/kb/72622 If this helps, please click the Yes button. Cheers, Shane Devenshire "shabutt" wrote: I have my data table in one sheet named "CODE" and lookup value table named "INDEX" in another. I have this formula =IF(A4="","",VLOOKUP(A4,INDEX!$A$3:$C$1872,3,FALSE )) which runs down to 19000 in sheet "CODE". It takes a lot of time to recalcualte/save. I think the vlookup is causing the workbook to slow down. What function could be used instead of vlookup to improve the calculation speed. Please help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative of Vlookup function which improves speed
Hi,
It's a pity that nowadays we get links instead of real answers. I didn't progress much reading these links. Sorry. Still looking for answer. "shabutt" wrote: I have my data table in one sheet named "CODE" and lookup value table named "INDEX" in another. I have this formula =IF(A4="","",VLOOKUP(A4,INDEX!$A$3:$C$1872,3,FALSE )) which runs down to 19000 in sheet "CODE". It takes a lot of time to recalcualte/save. I think the vlookup is causing the workbook to slow down. What function could be used instead of vlookup to improve the calculation speed. Please help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative of Vlookup function which improves speed
An INDEX/MATCH combination can often be faster than VLOOKUP, so try
this: =IF(A4="","",INDEX(INDEX!$C$3:$C$1872,MATCH(A4,IND EX!$A$3:$A$1872,0))) Hope this helps. Pete On Nov 24, 6:18*am, shabutt wrote: Hi, It's a pity that nowadays we get links instead of real answers. I didn't progress much reading these links. Sorry. Still looking for answer. "shabutt" wrote: I have my data table in one sheet named "CODE" and lookup value table named "INDEX" in another. I have this formula =IF(A4="","",VLOOKUP(A4,INDEX!$A$3:$C$1872,3,FALSE )) which runs down to 19000 in sheet "CODE". It takes a lot of time to recalcualte/save. I think the vlookup is causing the workbook to slow down. What function could be used instead of vlookup to improve the calculation speed. Please help.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alternative to VLOOKUP | Excel Worksheet Functions | |||
Which is faster? SUMPRODUCT or VLOOKUP, or another alternative? | Excel Worksheet Functions | |||
Vlookup Alternative Needed | Excel Discussion (Misc queries) | |||
Nested Vlookup or alternative? | Excel Worksheet Functions | |||
Alternative to Vlookup/Hlookup to return a value. | Excel Worksheet Functions |