Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Question about this formula... | Excel Worksheet Functions | |||
Formula question | Excel Discussion (Misc queries) | |||
formula question | Excel Discussion (Misc queries) |