OK everyone. I figured it out using the Find function. It turns out
to be plenty fast on a laptop.

I'm going to give you the full code since there is nothing proprietary
and it has been thoroughly tested. If you take my user case as a
guide, you'll be able to see what I did.

The code is initiated by a button on the "Instructions" Sheet. It can
only be activated after certain other conditions are satisfied that
have set up the two Sheets, "Employees" and "Managers", that are used
for the look up process. The "Employees" sheet  is generated from the
corporate database which is not always up to date, or may have had
ex-employees' names removed thereby causing an no match  condition.

The keys to making this work  is to be explicit in specifying the
Sheets().Cells(), Sheets().Columns(), and other cell references,
because the default of ActiveSheet, etc., sometimes gets confused.
Further, I use 'On Error' clauses to handle the not found condition.

FYI, my next step I am doing today. It will then take the "Travel
History" Sheet and distribute it by Department to the various Managers
by email.