Formula Question
 

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.

Formula Question
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robert B." wrote:
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.

Formula Question
 

Max

I will give that a try. Thanks Much

Robert B.

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robert B." wrote:
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.

Formula Question
 

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" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robert B." wrote:
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.

Formula Question
 

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,COLU MNS($A:A)+1,0))
Copy across to E8, fill down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robert B." wrote:
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.

Formula Question
 

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" wrote:

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,COLU MNS($A:A)+1,0))
Copy across to E8, fill down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robert B." wrote:
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.

Formula Question
 

welcome, Robert. good to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robert B." wrote in message
...
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.