Almost everyone who uses Excel has that one function they’ve been relying on since college because it works well enough that they can avoid learning something new. That’s why you’ll still find VLOOKUP ...
If Excel is not using threads efficiently, calculations may take a long time to complete. Learn how to speed up calculating threads in Excel.
Excel table formulas shift from cell positions to named columns with #All-style tags, keeping calculations readable when layouts change.