Suggest that you read the help index for LOOKUP and VLOOKUP, especially
about the sorting issue.

--
Don Guillett
SalesAid Software

"Knox" wrote in message
...
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!