Lookup & Reference Function - CHOOSEROWS

This amazing and new function from Office 365 enables you to return specific rows of data from an array!

The video shows the CHOOSEROWS function in use.

The written calculation is below:

=CHOOSEROWS(B3:D8,2,4,6)

​In this example, B3:D8 is the array or original data. The next arguments, 2, 4 and 6, are the rows of data we want to return as a result of using the CHOOSEROWS function. You can include as many of these row_num arguments as you need. Impressive stuff!