LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 45
Default limits on lookup function?

I have found that the lookup function does not work if it is sifting through
lots of records. Also it seems to work better if the data is sorted. Is
there any limit on the number of records for the lookup function? Does
sorting the data help? What exactly are the limits to the lookup function?
thank you!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Overcome LOOKUP limits and NOW() edwardpestian Excel Worksheet Functions 5 June 25th 06 06:34 PM
Function for upper and lower control limits? CaptAndy Excel Worksheet Functions 1 March 29th 06 03:09 PM
Limits of MINV matrix function KJ Excel Worksheet Functions 2 September 16th 05 09:06 AM
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM
How do i set up if function with more than level limits? Nested If Condition Excel Worksheet Functions 1 October 28th 04 06:12 PM


All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"