vlookup function

  • Thread starter Thread starter Marius
  • Start date Start date
M

Marius

When I use vertical lookup in Excel 20002 the results are
inconsistent. Quite often no results will be returned
despite a matching record being present in the lookup
range. Also autofill skips matching records for several
cells after it hits a cell with no matching result
 
All it takes is an extra space (for text) and the lookup will fail,
AFAIK there are no documented examples that it would fail if any
of the lookup values are exact to any of the values in the table.
You can test with 2 values you know match

=EXACT(A1,Sheet2!A2)

as an example
 
Check your lookup target value and your lookup table values to make sure
they're the same type. Often a number will be entered as text, either in
lookup target reference or in the lookup table itself. VLOOKUP doesn't
convert text "numbers" to numbers for hte purposes of matching.
 
Back
Top