All,

I am trying to create a formula by which when something is selected from
Column A (using a drop down menu) it will automatically fill in information
for Column B and C. I have 24 names in the drop down menu for Column A. I
want it to when a certain name is selected it will automatically select the
correct company and city from a list and input into Column B and C. Any help
you can provide will be greatly appreciated.


Example
John, Comp A, Jacksonville
Betty, Comp B, Richmond
Suzzie, Comp C, Los Angeles
and so on

Robert B.