I bet you are mistaken, what's the array and how does your formula look?
If you set it to look in a column not within the array it will throw the ref
error

--


Regards,


Peo Sjoblom

"lezaheam" wrote in message
...
I'm using VLookup on a array of five column.
It works fine except if I lookup on the last column of the array.
It returns a "#REF!" error.

Is there a known problem with VLookup and the last column of arrays?

thanks