Wow! Thank you! This is really great. And yes, I can be coached through VBA. This is already a great help, and if you have any desire to modify this, what I am really looking for is to enter bulk company names (the are pretty exactly correct) and to have a ticker returned in the next column. As an added challenge, some of the stocks are on foreign stock exchanges and so I would need their country "tag". For example, EDF Energies Nouvelles SA is a French company that trades on the Paris stock exchange so it's ticker is "FR:EEN" or sometimes "EEN.FR". Using your example, Boeing is "US:BA"

But any way, thank you so much for helping me and even if I never hear from you again you have been a great help and I sincerely thank you. Cheers to you and yours!!