How To Use Excel's LOOKUP Function ... index_num specifies" the row number from which to return the corresponding value. The ...

The INDEX formula doesn’t recognize column letters, so you must use numbers (counting from the left). The syntax for the MATCH function is: MATCH(lookup_value, lookup_array, [match_type]).