
6 reasons why your VLOOKUP is not working
13 April 2014
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.