Most Excel users know OFFSET returns a reference to a range of cells, but there are actually 8 functions that return references. Download the Excel file here: https://www.myonlinetraininghub.com/excel-functions-that-return-references
Chapters:
0:00 OFFSET
5:47 INDEX
10:21 XLOOKUP
11:04 CHOOSE
13:27 SWITCH
14:36 IF
15:38 IFS
16:26 INDIRECT
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/