Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using Array Formulas
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Writing Arrays to the worksheet - VBA function
- Linking Excel to C
Recent Comments
Tag Archives: XLookup
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