Thank you to all who contributed. The final solution I adopted (in case
anyone was watching this thread) was to create a small 1-dimensional array
and use Application.Match (exact match) to see if each successive key was
already in the new array or not. I used IsError on the return value from the
Application.Match to handle the NA() value that is returned if the item is
not found in the array. If it was an error [NA()], then I ran the code to
add my key to the small array, and then captured the rest of the info from
my larger array that corresponded to that value. Clean and simple, much
better than what I started with. Thanks again,
Keith