View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lezaheam lezaheam is offline
external usenet poster
 
Posts: 2
Default Vlookup "#REF!" error when using last column of array

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