My thanks to all who replied. Just examining your approaches has been
educational helping to clarify my thinking with respect to how Excel
macros function  in general.

In particular, this example serves to illustrate the difference
between using a function such as VLOOKUP in a spreadsheet verses within
a macro.