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.
Thank you for wwriting this