Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overcome LOOKUP limits and NOW() | Excel Worksheet Functions | |||
Function for upper and lower control limits? | Excel Worksheet Functions | |||
Limits of MINV matrix function | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
How do i set up if function with more than level limits? | Excel Worksheet Functions |