Forum Discussion
Large File and Need to Have Formulas
Hi Everyone - I am working on a large data file and was looking for a schematic (or list) of how exactly excel formulas work For example: =if(B2=1,1,0) - would just look at one column (B)...
Of course VLOOKUP() doesn't check cells sequentially one by one, that's more complex mechanism. And it depends on which version of Excel you are, couple of years ago performance of such functions was dramatically improved. Now, in addition to VLOOKUP() and INDEX/MATCH we have XLOOKUP().
More about that is here
Excel performance - Tips for optimizing performance obstructions | Microsoft Docs
Excel performance - Performance and limit improvements | Microsoft Docs
Excel performance - Improving calculation performance | Microsoft Docs