View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default VLOOKUP in large Data sets of more than 16384 rows

Is the file you are trying to lookup from saved in Excel 5.0/95
version? This was limited to 16k rows.

Hope this helps.

Pete