Forum Discussion
Huge Excel spreadsheet- Slow calculation speed for formulas
I have an excel spreadsheet with about 300,000 records. I am applying a Vlookup formula on the first row and then trying to copy and paste special as formulas to the remaining rows. But, the calculat...
Hi Pooja,
Please try to use LOOKUP instead of VLOOKUP, but you have to sort the match column of the table array in ascending order before use it, and you have to use it as the below syntax:
=IF(<lookup_value> = LOOKUP(<lookup_value>, match_column), LOOKUP(<lookup_value>, table_array), "NA")
Please see the attached file for an example.
Regards