Implicit intersection in Excel

Implicit intersection is the rule that lets a formula written for a single cell quietly pick one value from a range instead of returning an error.

That behaviour made legacy formulas work, and it also hid mistakes: a lookup returning an unexpected row still produced a number.

Dynamic arrays replaced the rule with the at-sign operator, so a reviewer who sees an at-sign is looking at a deliberate single-value choice.

More definitions

Twenty-five terms a reviewer needs, each in one sentence followed by the context that matters.