When you open an Excel spreadsheet, by default the columns are indexed by letters. However if you'd like to change the format and have the index in numbers, follow the step-by-step guide below. How to ...

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]).