Indirect Address Problem

  • Thread starter Thread starter stew
  • Start date Start date
S

stew

Hi All

Jacob Skaria Kindly helped me with this problem and I thought we had the
answer however

Small Problem with this Formula

When we reach row 960 the indirect instruction starts at 'Road Cash
Accounting'$I$10 again when it should carry on to $I$430.This applies through
to the end of the Sheet

Can Anybody help
 
Try the below

(in one line...)
=INDIRECT("'Road Cash
Accounting'!"&ADDRESS(10+((ROW()-441)/49-1)*42,COLUMN()+1))

If this post helps click Yes
 
Back
Top