Explaining Display Cell Contents in Another Cell

=CellReference (e.g. =A12). This is used to get the data from the referenced cell from main order table. Usually this is used in conjunction with other formulas such as =IF and =IF(ISBLANK

Examples:

=IF(ISBLANK(Data!AT11),"",Data!AV11) - in the image below, the formula is looking for any value in cell AT11, if there is a value, then it returns the value from cell AV11
=AY11 - in the image below, the cell will copy the value directly from the reference cell, in this instance it’s 1000

Open