Cross-Sheet Reference

A reference to a cell on another sheet, written 'Sheet name'!J2. Single quotes are needed when the sheet name contains spaces, and a lookup range can be on another sheet too, as in feedback!$A$2:$A$51.

When to use

Seen in the If statements formulas, which read salary from 'Filters advanced'!J2 while the rule cells sit on the current sheet, and in the lookups into the feedback and Branches sheets. A formula can mix references to two sheets.

See Lec 02.

Appears in

No references yet.