Tag Archives: Indirect

Excel functions that return references and new functions

Posted on 30/06/2020 by dougaj4

The MyOnlineTrainingHub blog recently posted an article on: Excel Functions that Return References As well as comprehensive advice on the use of OFFSET, INDEX, CHOOSE, IF and INDIRECT, it also covers the new functions XLOOKUP (Excel for Microsoft 365 only), and … Continue reading →

Posted in Arrays, Excel | Tagged , , , , , , , , , | 1 Comment

Extracting data from a 3D range

Posted on 26/08/2009 by dougaj4

I recently needed to extract data from a series of tables on separate worksheets, into a form suitable for plotting on an XY graph.  In Lotus 123 this would be a piece of cake, since the Lotus @INDEX function has … Continue reading →

Posted in Arrays, Excel | Tagged , , , | 3 Comments