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.


"Max" wrote:

If the lookup value is numeric, try:
=VLOOKUP(A2+0,$J$2:$K$5815,2,FALSE)

If the lookup value is text, try:
=VLOOKUP(TRIM(A2),$J$2:$K$5815,2,FALSE)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Excell Rookie" <Excell wrote in message
...
I was having issues with Vlookup functionality in a 2 column array. It
does
not recognize the value I have in the array intil I over type the value
and
then the vlookup functionality works.

My equation looks like this: =VLOOKUP(A2,$J$2:$K$5815,2,FALSE)