Then the problem is with the table array which probably contains extraneous
leading and/or trailing spaces. Try this on a spare copy of your sheet ..

Using 2 empty adjacent columns ..
Put in say, L2: =TRIM(J2)
Copy across to M2, fill down to M5815

Then select L2:M5815, and do a copy paste special values to overwrite
the original table array in J2:K5815
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Excell Rookie" wrote in message
...
Thank You for the quick response, niether proposal has remedied the issue.
I am using data which is a "mix" of alpha, and numerical like AE61, ST04
etc When I retype these values into my arry, the VLOOKUP functionaly
works.