Indirect Address Problem

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indirect address 4
Help with indirect 5
Dependent Data Valadiation 0
INDIRECT Formula 3
Creating a Unique List 5
INDIRECT filldown problem 2
Duplication Macro 0
Indirect function with national language 7

Top