INDEX in Excel & Google Sheets
Returns the value at a row (and column) inside a range. Paired with MATCH, it is the classic lookup that searches left and survives inserted columns.
Syntax
=INDEX(array, row_num, [column_num]) Example: Find a price with INDEX + MATCH
=INDEX(C2:C6, MATCH(E2, A2:A6, 0)) =INDICE(C2:C6; COINCIDIR(E2; A2:A6; 0)) MATCH finds the row of the SKU in column A; INDEX returns the price from that row of column C.
INDEX in Spanish
In Spanish Excel and Google Sheets, INDEX is called INDICE. It's the same function: files translate automatically when opened in another language. When you type it by hand, the name and the argument separator change.
| English | Spanish | |
|---|---|---|
| Function | INDEX | INDICE |
| Separator | , | ; |
| Example | =INDEX(C2:C6, MATCH(E2, A2:A6, 0)) | =INDICE(C2:C6; COINCIDIR(E2; A2:A6; 0)) |
The separator depends on regional settings: Spanish versions usually use semicolons, but countries with a decimal point (like Mexico) may use commas.
Translate another formulaArguments
INDEX FAQ
What is INDEX in Spanish?
In Spanish, INDEX is INDICE. When you type it by hand in a Spanish Excel, arguments are usually separated by semicolons (;): =INDICE(C2:C6; COINCIDIR(E2; A2:A6; 0))
Does INDEX work in Google Sheets?
Yes. INDEX works in Google Sheets with the same syntax as in Excel. In a sheet set to Spanish it's called INDICE. The separator (comma or semicolon) follows the sheet's locale, under File → Settings.
Is INDEX + MATCH better than VLOOKUP?
It is more flexible: it can return columns to the left of the lookup column and doesn't break when you insert columns. In Excel 365 and Google Sheets, XLOOKUP does the same in a single function.