Your formulas aren't wrong.
They just run too often.

Drop the workbook that lags on every edit, or click to choose xlsx / xlsm / xltx / xltm · max 100 MB

Too big or slow to open? Slim it first →

standbyChoose a file

awaiting upload

volatile—

single-thread—

mode—

I use Microsoft 365 / Excel 2021+ (also use LET, IFNA, CONCAT) I have read and agree to the Privacy Policy and understand the file is uploaded to a server for processing

FAQ

Why does Excel freeze every time I edit a cell?

Volatile functions such as OFFSET, INDIRECT and TODAY recalculate on every edit; a VLOOKUP over a whole table recalculates when any of its columns changes; IF(ISERROR(X),…,X) computes X twice.

Will the results change?

Every rewrite passes three checks: the old formula evaluates to the cached value, old and new agree, and they still agree when inputs are swapped for blanks, zeros, negatives, text and other edge values. Anything unproven stays as is.

Why not switch VLOOKUP to XLOOKUP?

An equivalent XLOOKUP needs wildcard mode, which measured 4× slower, and the two differ when the lookup value is blank.

Your formulas aren't wrong.They just run too often.

FAQ

All tools

Your formulas aren't wrong.
They just run too often.