Your formulas, valid in every language

Excel, Google Sheets and LibreOffice use different function names, argument separators and decimal marks in each language, so a formula copied from one language often breaks in another. Formula Passport looks up the right names and separators — verified against the official Microsoft, LibreOffice and Google sources — so your formula works wherever you paste it.

=VLOOKUP(A2, Prices, 2, FALSE)

Verified · valid in 6 languages

  • German=SVERWEIS(A2;Prices;2;FALSCH)
  • Spanish=BUSCARV(A2;Prices;2;FALSO)
  • French=RECHERCHEV(A2;Prices;2;FAUX)

Open the formula translator