Alternative of Vlookup function which improves speed

[shabutt]

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.

 

[Teethless mama]

Take a look this site:
http://www.decisionmodels.com/optspeedb.htm

 

[Shane Devenshire]

Hi,

Here are three Microsoft sites addressing this topic:

http://support.microsoft.com/kb/825012
http://msdn.microsoft.com/en-us/library/aa140058(office.10).aspx
http://support.microsoft.com/kb/72622

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

 

[shabutt]

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.

 

[Pete_UK]

An INDEX/MATCH combination can often be faster than VLOOKUP, so try
this:

=IF(A4="","",INDEX(INDEX!$C$3:$C$1872,MATCH(A4,INDEX!$A$3:$A$1872,0)))

Hope this helps.

Pete