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 IFS and SWITCH (new in Excel 2019). There is also a worksheet for free download, including all the examples given in the article.
| SectionProperties up… on Section Properties with MeshPY… | |
 | dougaj4 on Beam geometric non-linear… |
| dougaj4 on Non linear regression –… |
 | Torben Jensen on Non linear regression –… |
 | robertocastanocrespo on Beam geometric non-linear… |
| dougaj4 on Cubic Splines |
 | Amar Khalifeh on Cubic Splines |
| dougaj4 on Finding square roots … |
 | Juggler_IN on Finding square roots … |
| dougaj4 on Tanh-Sinh Quadrature v. 5… |
 | metroxx on Tanh-Sinh Quadrature v. 5… |
| dougaj4 on Tanh-Sinh Quadrature v. 5… |
| metroxx on Tanh-Sinh Quadrature v. 5… |
| dougaj4 on Numerical Integration With Tan… |
| Tanh-Sinh Quadrature… on Numerical Integration With Tan… |
Newton Excel Bach, not (just) an Excel Blog 