What is the column index number
If array has more than one row and more than one column, and only row_num or column_num is used, INDEX returns an array of the entire row or column in array. row_num Required. Selects the row in array from which to return a value. If row_num is omitted, column_num is required. column_num Optional. The Col_index_num (Column index number) is the relative column number in the list. Nothing to do with where it is in Excel, it's the column number in the table. We want to retrieve the price, so type 2. The price is in the second column of the table. The Range_lookup argument is critical. Read its definition at the bottom of the Formula Palette. MATCH function returns the relative position of the cell G3 (Column name) in the Table 1 header range. Formula result is number 1 since “Store” is the first column in Table 1. Reference of the lookup_array for the Excel Table is different from the regular cell ranges. This array refers to the header of Table 1.