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.

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.

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.

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.

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 -