• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Indirect Farmula Vs Direct Link

M

Mudassar.freedi

New Member
Dear All,

Please help me to understand what is the difference in between Indirect Farmula & direct link reference?


thanks

Hafiz Mudassar
 
One of the most significant differences would be:


INDIRECT does not work with CLOSED workbooks. So as soon as you close the reference workbook it will give you error but the link wouldn't give you an error.
 
INDIRECT is mostly used when you need to build the reference, ie, the row number may be a variable from some other calculation, where as a direct link is when you want to always pull from the same cell.


Technically, another difference is that direct links look at the same cell, but INDIRECT looks at same location. Meaning, if you write this formula:

=B2

And then insert a row above row 2, the formula will automatically change to

=B3

because it's following the same cell. If you had written

=INDIRECT("B2")

and inserted a row, the formula does not change because you are always looking at the location "B2", not a particular cell.
 
You must log in or register to reply here.
Back
Top