Home / Tricks / XLOOKUP in 20 seconds
// trick 046 · Formulas

XLOOKUP in 20 seconds

The formula to copy, for Excel with Italian function names and for Google Sheets.

The formula

EXCEL (ITALIAN)=CERCA.X(F2;A:A;C:C;"non trovato")
GOOGLE SHEETS=XLOOKUP(F2;A:A;C:C;"non trovato")
// this trick is already inside

"Organize 2027" Bundle

All 5 templates in one purchase: save €10.70.

See the template