If the VLOOKUP function cannot find the value 53 in the first column, it will return a NA error.

Instead of returning the salary, the VLOOKUP function below returns the last name (third argument is set to 3) of ID 79.

If the VLOOKUP function cannot find the value 85 in the first column, it will return the largest value smaller than 85.

No worries, you can use INDEX and MATCH in Excel to perform a left lookup.

For example, the VLOOKUP function below looks up MIA (cell G2) in the leftmost column of the table.

As a result, the VLOOKUP function returns the salary of Mia Clark (first instance).

If youre using Excel 2010 or Excel 2007, simply replace IFNA with IFERROR.

For example, the NAME error if you accidentally misspell the word VLOOKUP.

If UK, the VLOOKUP function uses Table1, if USA, the VLOOKUP function uses Table2.

Set the fourth argument of the VLOOKUP function to TRUE to return an approximate match.

Because were using named ranges, we can easily copy this VLOOKUP function to the other cells without worrying about cell references.

Maybe this is one step too far for you at this stage, but it shows you one of the many other powerful formulas Excel has to offer.

The XLOOKUP function is easier to use and has some additional advantages.

Vlookup Not Working In Excel For Mac