...
=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
...