Tag Archives: Indirect

Excel functions that return references and new functions

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 , , , , , , , , , | Leave a comment

Extracting data from a 3D range

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