An Excel sheet containing an array of data in a table, and the result of a CHOOSEROWS formula. An Excel sheet containing each team's scores across three leagues.

table_array: this is the range of cells within which you're looking for the data. For example, if people's names are in three columns from B to D, ... What Is the Meaning of an Excel Formula?.

The source data can, and should, be in a Table, but don’t enter the actual function into a Table. Excel’s built-in dynamic array functions are easy to use and easy to maintain as long as you ...

Microsoft Excel's dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP().