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?.

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