Excel formula to look up a value

Look up a code or value in a table and return related data.

CERCA.VERT: =CERCA.VERT(A2;F:G;2;FALSO)
CERCA.X: =CERCA.X(A2;F:F;G:G;"Non trovato")

VLOOKUP: =VLOOKUP(A2,F:G,2,FALSE)
XLOOKUP: =XLOOKUP(A2,F:F,G:G,"Not found")

Example

If A2 contains a product code, it returns the description from table F:G.

Common error

VLOOKUP searches only in the first column of the range.

How it works

VLOOKUP is compatible with old versions but has limitations.

XLOOKUP is more modern but not available in Excel 2010.

Does XLOOKUP work in Excel 2010?

No.

Why does VLOOKUP return #N/A?

Value not found or wrong range.