Is there a way to have a drop-down list fill two columns (actually, two adjacent cells) when a selection is made from the drop-down list? Maybe using an array in the source formula?
For instance, let's say I pick a doctor from the drop down list, I would like the doctor's practice to automatically fill the cell next it so that the two always go together correctly. In the lists example below, when I select Dr. Elmer in column A, then I want Internal Medecine Associates to go in column B.
MD Practice
Dr. Bartholomew Central Endocrine Specialists
Dr. Elmer Internal Medicine Associates
Dr. Stamford Cardiology Associates
Bookmarks