vlookup excel

[r.gardiner]

when using numerals only vlookup works well, but alphanumerical returns
deatils from the cell above the correct one. Has anyone any idea what i'm doing
wrong.
many thanks
r.gardiner

 

[DDM]

r.gardiner, add the fourth argument, FALSE, to your VLOOKUP formula, thus:
=VLOOKUP(A1,A10:B15,2,FALSE). That will compel it to find an exact match.

 

[Frank Kabel]

Hi
you probably have to add the 4th parameter of VLOOKUOP (setting it to
FALSE) to get an exact match.
But for a more specific answer simply post your current formula