I would select the Doctor's name from a Userform list or combobox. You could populate the list or combobox using the excel worksheet.

Some tips for doing this sort of thing is shown here: http://gregmaxey.com/word_tip_pages/..._combobox.html

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Sorry, I must be naive. I just wanted to know a simple way to be able to type in the first one or two letters of a doctor's name, and have corresponding names appear for me to select one of, and have the corresponding address appear. I'd need a step by step set of instructions.
It looks like coding is required. Which is beyond me.
I can add a combo box. That requires me to input each name.

This is all a bit obfuscating.
Thanks for your effort.
I suspect I need to know more about how this works than I do.

Cheers.