Alternative of Vlookup function which improves speed

S

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top