April 2012
1 post
Two Ways to Use the INDEX Function to Return an...
Normally, to return column 2 of a named range, you would use the following formula =INDEX(myTable,0,2). The zero means: return all rows (of column 2).
If you want to return row 2 of the named range you would use =INDEX(myTable,2,0). Here the zero means: return all columns (of row 2).
This comes from the Help section of the INDEX function where in Excel 2011 it reads:
If you set row_num or...
