TIL: Avoid using too many MATCH() functions in Excel

Yet another interesting finding in Excel.

Today, I tried INDEX+MATCH to track and filter data from an external spreadsheet. However, after inserting hundreds of these functions, Excel freezed for ever. A quick research shows that it's a known issue of MATCH() which is extremely slow in Excel.

So, the best practice is not to use MATCH(). If you have to, try to store the results of MATCH() functions in hidden cells and reuse them as much as possible.


Max Lv

A programmer focusing on High-performance Computing.

comments powered by Disqus