Excel’s CHOOSE function with array
How to return an array of non-adjacent cells in Excel.
Excel Advanced
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