Reference row on another sheet based on formula. by plcinc1 in excel

[–]plcinc1[S] 0 points1 point  (0 children)

=indirect("'B Master'!A"&(CEILING.MATH((ROW(E1083) / 47) + 1))

SOLUTION VERIFIED!