What RECHERCHEV means, its English equivalent, and how to convert a French lookup formula for English Excel.
If you have opened a French Excel file or copied a formula from a French source, you have probably met RECHERCHEV. It is not a different function — RECHERCHEV is exactly VLOOKUP. Same arguments, same behaviour; only the name is translated into French.
RECHERCHEV comes from recherche verticale — "vertical lookup" — which is precisely what VLOOKUP does: it searches down the first column of a range and returns a value from a column to the right.
The syntax is identical. The same lookup in both languages:
French: =RECHERCHEV(A2;Table;2;FAUX)
English: =VLOOKUP(A2,Table,2,FALSE)
Three things change between them:
RECHERCHEV → VLOOKUP; → commas , (French Excel is semicolon-based)VRAI/FAUX → TRUE/FALSE| French | English |
|---|---|
RECHERCHEV | VLOOKUP |
RECHERCHEH | HLOOKUP |
RECHERCHEX | XLOOKUP |
EQUIV | MATCH |
INDEX | INDEX (same) |
Paste the French formula into the formula translator, set the source to French and the target to English, and it rewrites the name, separators and constants together. For one function, the VLOOKUP page shows the name in all nine languages with syntax and examples. For more French names, see French Excel functions and their English equivalents.
If you are just opening a French workbook in your English Excel, no — Excel already shows VLOOKUP. You only translate when you are copying the formula text into a different-language Excel, where the raw word RECHERCHEV would trigger a #NAME? error.
RECHERCHEV = VLOOKUP, exactly.VRAI/FAUX → TRUE/FALSE.