Formula Question

[Robert B.]

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.

 

[Max]

One way

Assuming this reference listing is in Sheet2, cols A to C, from row1 down

John, Comp A, Jacksonville
Betty, Comp B, Richmond
Suzzie, Comp C, Los Angeles

In the other sheet,
Assume the droplist for the names (John, Betty,..) is in A1,
Put in B1:
=IF($A1="","",VLOOKUP($A1,Sheet2!$A:$C,COLUMNS($A:A)+1,0))
Copy B1 across to C1

 

[Robert B.]

Max

I will give that a try. Thanks Much

Robert B.

 

[Robert B.]

Max,

I input the formula below and created the data on a sheet called
Delivery_Info (data is in A,B,C Columns starting with row 1.

On other worksheet I input the formula in column D row 8 (will replicate it
after and copy down a number of rows). Column C has drop down menu for name.
Excel is telling me it is an error in value? I am not sure what to change.

Robert B.

 

[Max]

Based on your set-up as described, try this adaptation
In the other worksheet,
In C8 down are the droplists for the names: John, Betty, etc
Put in D8:
=IF($C8="","",VLOOKUP($C8,Delivery_Info!$A:$C,COLUMNS($A:A)+1,0))
Copy across to E8, fill down as far as required

 

[Robert B.]

Max

This code is working great. I added a few more columns of data and figured
it out.

Thanks so much for your excellent help.

Robert B.

 

[Max]

welcome, Robert. good to hear that.