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