View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bluewolf Bluewolf is offline
external usenet poster
 
Posts: 1
Default How do I expand Excel lookup function to search more than 16,3

Hi Niek,

I am hitting the same barrier as Rusty with same version of Excel. If you
can help please look at my post 3/27/06 VLOOKUP in Data sets of more than
16384 rows
--
A charming and handsome, highley intelectual adept levle Excel user.


"Niek Otten" wrote:

Do you mean VLOOKUP? There is no such limit.
What do you see that makes you think so?

--
Kind regards,

Niek Otten

"Rusty" wrote in message
...
Excel 2003 limits lookup functions to searching 16,384 row of the source
worksheet. Is there a way to expand this window?