Maybe

=IF(Z46="","",INDIRECT("Draw1!Z"&Z46+14))
VBA Noob