6 reasons why your VLOOKUP is not working

The VLOOKUP function is the most popular lookup and reference function in Excel. It is also one of the trickiest and the dreaded #N/A error message can be a common sight.

This article will look at the 6 most common reasons why your VLOOKUP is not working:

• You need an exact match.
• Lock the table reference.
• A column has been inserted.
• The table has got bigger.
• VLOOKUP cannot look to its left.
• Your table contains duplicates.