vlookup

[r.gardiner]

Using numbers (ie 2345 or 9874) vlookup works very well but when i use
alphanumeric(ie st345 or 5678y) it returns the value of the cell
directly above the correct one. the table is sorted ascendingly.
Please help.
Thanks