View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bartimus
 
Posts: n/a
Default how do I perform a lookup on an 80,000 line array?

I am trying to perform a standard vector LOOKUP on some data I have. The
problem I am facing is that my data array contains over 83 thousand lines and
Excel will only work with 65536 lines. What am I supposed to do here? I
need the LOOKUP to work to replace city and state based on a zip code look up.