Excel INDIRECT function with INDEX MATCH
Worked example on how to use Excel INDIRECT INDEX MATCH combined, including syntax for INDIRECT and INDEX MATCH.
Excel Advanced
Excel LAMBDA functions
How to create and use Excel Lambda functions in Excel 365
Dynamic array of latest values from a table in Excel
In this detailed worked example, we show step by step how to retrieve a dynamic array of values, using a range of Excel’s functions including OFFSET, INDEX MATCH, INDIRECT, and ADDRESS.
Excel’s CHOOSE function with array
How to return an array of non-adjacent cells in Excel.
VLOOKUP Excel function – explanation and examples
How to use the VLOOKUP function in Excel
CHOOSE function with LINEST in Excel
Use functions CHOOSE and RIGHT to create an array of values which includes mixed data types, to feed a LINEST calculation