INDIRECT: How to Use Text as a Cell Reference in Excel

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.

Goal-Seek in Excel: Easily Achieve Your Desired Result!

You’ve done some calculations in Excel but you aren’t satisfied with the result? So you ask yourself, how you could achieve the desired result. A good starting point for such analysis is the built-in Goal Seek function in Excel. It’s simple to use but yet powerful. On the other side, it does some reverse calculation and therefore has a reputation for cheating in order to achieve the target results.