Excel functions that return references and new functions

Posted on June 30, 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 IFS and SWITCH (new in Excel 2019).  There is also a worksheet for free download, including all the examples given in the article.

This entry was posted in Arrays, Excel and tagged , , , , , , , , , . Bookmark the permalink.

1 Response to Excel functions that return references and new functions

  1. Aden says:
    May 22, 2022 at 7:14 pm

    Thank you for wwriting this

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.