lookup(all) exportcell

[David Thompson]

>  > An ArrayBuild treats each record in turn as
>>  temporarily current, so you should be able to use
>>
>>  ArrayBuild MyArray, sep, "", ?(KeyField=KeyValue, exportline(), "")
>
>Thanks, Dave. I tried that, and it certainly works, but was pretty
>slow (15,000 records).

SuperArrayBuild should be faster. It wouldn't be evaluating the 
exportline() function 15,000 times, and using it only once. It would 
only be doing it for records that satisfied the condition, and with 
maxrecords set for 1, it would stop after it had found one. You could 
also have it search from the bottom up, instead of from the top down, 
if there was reason to believe it would be near the bottom.

Dave