Yet another interesting finding in Excel.
Today, I tried
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.