Home › Excel guides › RECHERCHEV = VLOOKUP: the French lookup function in English

RECHERCHEV = VLOOKUP: the French lookup function in English

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.

What RECHERCHEV means

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.

RECHERCHEV ↔ VLOOKUP

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:

The French lookup family

FrenchEnglish
RECHERCHEVVLOOKUP
RECHERCHEHHLOOKUP
RECHERCHEXXLOOKUP
EQUIVMATCH
INDEXINDEX (same)

Converting a RECHERCHEV formula

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.

Do you need to translate at all?

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.

Key takeaways

← All Excel guides

Copied to clipboard