INDIRECT functions are often a bit complicated to follow up. They can be useful, especially for referring to different sheets but not easily to evaluate. Here are three methods to follow up INDIRECT functions in Excel. Method 1: Use the INDIRECT manager to follow up INDIRECT function The first method is most convenient. Our Excel… Continue reading Follow Up INDIRECT: How to Easily Evaluate INDIRECT Functions
You want to get data from different sheets but always on the same cell? INDIRECT returns the value of a cell which you specify by a string. For example, if you write =INDIRECT(“B2”) it’ll give you the value of B2. Instead of just B2, you can also refer to other sheets, for example =INDIRECT(“Sheet1!B2”) or even other workbooks.