On a worksheet “ListsAmpl” there are two dynamic named ranges side by
side of equal length SysNamListDesig and SysNamList. …ListDesig
contains alphanumeric designators and …List contains corresponding
Titles. (I could just use one name as well if need be)

On a separate worksheet "Data Entry" there are several columns of data
and I need to scan the data and test each cell to see if any of the
SysNamListDesig items are present and if they are insert the
corresponding title after the designator in the cell.

Any help will be appreciated.
Robert