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.
|