Are A2 and each cell in your lookup range all formatted as numbers? If
a cell in the lookup range is formatted as text (or if the number is
entered with a leading apostrophe, which forces the cell to be text),
and A2 is a number, that will likely result in a mismatch.