Lookup & Reference
In the following an alphabetically sorted list of all Excel functions for the category Lookup & Reference of the current version of Microsoft Excel as well as their translations in the selected language. Please note, that in earlier versions of Excel the translations may be different. A detailed list of the translations for each function from Microsoft Excel 2010 and above can be found in the linked article.
Translations
| Product | Microsoft Excel (Office 365) |
| Category | Lookup & Reference |
| Source language | English |
| Target language |
| A | German |
|---|---|
| ADDRESS | ADRESSE |
| AREAS | BEREICHE |
| C | German |
|---|---|
| CHOOSE | WAHL |
| COLUMN | SPALTE |
| COLUMNS | SPALTEN |
| F | German |
|---|---|
| FORMULATEXT | FORMELTEXT |
| G | German |
|---|---|
| GETPIVOTDATA | PIVOTDATENZUORDNEN |
| H | German |
|---|---|
| HLOOKUP | WVERWEIS |
| HYPERLINK | HYPERLINK |
| I | German |
|---|---|
| INDEX | INDEX |
| INDIRECT | INDIREKT |
| L | German |
|---|---|
| LOOKUP | VERWEIS |
| M | German |
|---|---|
| MATCH | VERGLEICH |
| O | German |
|---|---|
| OFFSET | BEREICH.VERSCHIEBEN |
| R | German |
|---|---|
| ROW | ZEILE |
| ROWS | ZEILEN |
| RTD | RTD |
| T | German |
|---|---|
| TRANSPOSE | MTRANS |
| V | German |
|---|---|
| VLOOKUP | SVERWEIS |