I have an array of n records with 2 fields (say, "Name" and "Date"),
and a worksheet table of many rows (eventually thousands) and many
columns, including the two columns in the array. I need to compare
each record in the array to find out if that Name/Date combo already
exists in any row of the spreadsheet table. (...and add it to the
table if not already represented but that's the easy part) Although
the number of rows in the table will become large, n will usually be
<10.

I can think of various ways to proceed (using various permutations of
autofilter, .find, concatenating, etc.) but none are particularly
elegant.

Is there one approach that is more programmatically "correct" than the
others?

I know enough to get the job done but it might not be very pretty.
I'm teaching myself as I go and I'd like to teach myself "right" if
there's a "right" way. Thanks! -Lisa