Index With Rows and Columns

This video shows how to use the INDEX function to pick off an entire row or column.

These are the two files needed to follow along to this video:

INDEX FINISH

INDEX FOR ROW OR COLUMN FINISH