Excel’s INDIRECT Function has many applications and perhaps its simplest is to fix a range of cells you want to reference. For example a standard SUM function looks like this: =SUM(B16:B24) If you insert a row within this range the formula dynamically updates and becomes: =SUM(B16:B25) It will dynamically update even if you absolute the [...]
December 2011
For some of us we use the VLOOKUP function all the time and for the most part is does exactly what we want, but what if you want to lookup multiple columns? Taking the example below; in cell B3 I have a data validation list that allows me to choose the player I want to [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
