Excel Sheet Index Function. The cell function uses the return value of index as a cell Index and match with horizontal table.
In the example, the reference argument contains two ranges in the form of named ranges hp and defense.since the area_num argument is 2, the index function evaluates the second area (range) in given references. In the following picture, you can see multiple worksheets open in a single workbook. Function uses area_num argument which is viable for the reference form of the index function.
Excel Sheet Index Reference. An index number is a sequential number assigned to a sheet, based on the position of its sheet tab (counting from the left) among sheets of the same type. Depending on the formula, the return value of index may be used as a reference or as a value.
Another thing you need to know when creating references by selecting the sheet and then the cell/range is that excel will always create a relative reference (i.e., references with n0 $ sign). For instance, if we have data in cell a2 and want to use that in cell a1, use =a2 in cell a1, and this will copy the a2 value in a1. In a typical formula, you'll see the value in cell a2 as the result, so it's not obvious that index is returning a reference.