Thank you for the link - this solution posted by rahul.gandhi was the one that fixed my problem!
There is a very simple fix for this.
1. Open Excel
2. Click the Microsoft button (Round button top left)
3. Click on the Excel Options button
4. Select Add-ins on the left menu
5. At the bottom of the screen make sure the pull-down window says excel add-ins
6. Click Go
7. Enable the look-up wizard
8. Put a check mark beside Lookup Wizard
9. Click OK
In some cases, Microsoft might mention that the add-on is not installed and ask if you want to install it. Select Yes and let it run through the installation. When it is finished, you will not get a confirmation, but the installation window will be gone.