Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Multiple cells when choosing one selection from drop down
I have created a basic Work Order with drop downs, worls great. Now I would
like to add customers to a worksheet drop down. Once I select the customers name, I would like to fill in address, Phone, Customer ID, etc. in work order to print invoice. I will put all this info into a worksheet in the workbook. How can I do this in Excel. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Multiple cells when choosing one selection from drop down
Hi,
Create a table with all the info then use a VLOOKUP function to retrieve the info, so if A1 is your drop down menu then. =VLOOKUP($A$1,your table range,2,0) the 2 in the formula represent the column number in the table, you can replace it with either a COLUMN function or ROW function to make it easier to copy across or down. e.g. =VLOOKUP($A$1,your table range,COLUMN(B1),0) ...copied across =VLOOKUP($A$1,your table range,ROW(A2),0) ....copied down B1 and A2 refers to the second column in the table.... don't forget to make your table range aboslute ($B$1:$F$100) or you can name your table and use that name in the forumula instead. HTH Jean-Guy "MMANDIA" wrote: I have created a basic Work Order with drop downs, worls great. Now I would like to add customers to a worksheet drop down. Once I select the customers name, I would like to fill in address, Phone, Customer ID, etc. in work order to print invoice. I will put all this info into a worksheet in the workbook. How can I do this in Excel. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Multiple cells when choosing one selection from drop
Jean, You just went way over my head... Can you show me a sample file...
Thanks for the quick response. "Jean-Guy" wrote: Hi, Create a table with all the info then use a VLOOKUP function to retrieve the info, so if A1 is your drop down menu then. =VLOOKUP($A$1,your table range,2,0) the 2 in the formula represent the column number in the table, you can replace it with either a COLUMN function or ROW function to make it easier to copy across or down. e.g. =VLOOKUP($A$1,your table range,COLUMN(B1),0) ...copied across =VLOOKUP($A$1,your table range,ROW(A2),0) ....copied down B1 and A2 refers to the second column in the table.... don't forget to make your table range aboslute ($B$1:$F$100) or you can name your table and use that name in the forumula instead. HTH Jean-Guy "MMANDIA" wrote: I have created a basic Work Order with drop downs, worls great. Now I would like to add customers to a worksheet drop down. Once I select the customers name, I would like to fill in address, Phone, Customer ID, etc. in work order to print invoice. I will put all this info into a worksheet in the workbook. How can I do this in Excel. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Multiple cells when choosing one selection from drop
I would like to send you my file so you can see what I have.
Mike "Jean-Guy" wrote: Hi, Create a table with all the info then use a VLOOKUP function to retrieve the info, so if A1 is your drop down menu then. =VLOOKUP($A$1,your table range,2,0) the 2 in the formula represent the column number in the table, you can replace it with either a COLUMN function or ROW function to make it easier to copy across or down. e.g. =VLOOKUP($A$1,your table range,COLUMN(B1),0) ...copied across =VLOOKUP($A$1,your table range,ROW(A2),0) ....copied down B1 and A2 refers to the second column in the table.... don't forget to make your table range aboslute ($B$1:$F$100) or you can name your table and use that name in the forumula instead. HTH Jean-Guy "MMANDIA" wrote: I have created a basic Work Order with drop downs, worls great. Now I would like to add customers to a worksheet drop down. Once I select the customers name, I would like to fill in address, Phone, Customer ID, etc. in work order to print invoice. I will put all this info into a worksheet in the workbook. How can I do this in Excel. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Multiple cells when choosing one selection from drop down
I would love to email you my file so you can see what I have.
"MMANDIA" wrote: I have created a basic Work Order with drop downs, worls great. Now I would like to add customers to a worksheet drop down. Once I select the customers name, I would like to fill in address, Phone, Customer ID, etc. in work order to print invoice. I will put all this info into a worksheet in the workbook. How can I do this in Excel. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Multiple cells when choosing one selection from drop
Debra Dalgleish has a sample order form that you can download.
It has drop down examples together with Vlookup formulas that should answer all your questions. http://www.contextures.com/xlOrderForm01.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "MMANDIA" wrote in message ... I would like to send you my file so you can see what I have. Mike "Jean-Guy" wrote: Hi, Create a table with all the info then use a VLOOKUP function to retrieve the info, so if A1 is your drop down menu then. =VLOOKUP($A$1,your table range,2,0) the 2 in the formula represent the column number in the table, you can replace it with either a COLUMN function or ROW function to make it easier to copy across or down. e.g. =VLOOKUP($A$1,your table range,COLUMN(B1),0) ...copied across =VLOOKUP($A$1,your table range,ROW(A2),0) ....copied down B1 and A2 refers to the second column in the table.... don't forget to make your table range aboslute ($B$1:$F$100) or you can name your table and use that name in the forumula instead. HTH Jean-Guy "MMANDIA" wrote: I have created a basic Work Order with drop downs, worls great. Now I would like to add customers to a worksheet drop down. Once I select the customers name, I would like to fill in address, Phone, Customer ID, etc. in work order to print invoice. I will put all this info into a worksheet in the workbook. How can I do this in Excel. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Multiple cells when choosing one selection from drop
Hi,
There's really no need, try this and if you can't get it working after then you can send it to me! just open a blank worksheet, in cells F1 to F4 type a few customer names, in cells G1 to G4 type their phone numbers, in cells H1 to H4 their address...in B1 type =VLOOKUP($A$1,$F$1:$G$4,ROW(A2),0) and copy down to B2, now type any customer name from the table to see their info. Regards! Jean-Guy dotcom "MMANDIA" wrote: I would love to email you my file so you can see what I have. "MMANDIA" wrote: I have created a basic Work Order with drop downs, worls great. Now I would like to add customers to a worksheet drop down. Once I select the customers name, I would like to fill in address, Phone, Customer ID, etc. in work order to print invoice. I will put all this info into a worksheet in the workbook. How can I do this in Excel. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Multiple cells when choosing one selection from drop
Thanks..
:) "Ragdyer" wrote: Debra Dalgleish has a sample order form that you can download. It has drop down examples together with Vlookup formulas that should answer all your questions. http://www.contextures.com/xlOrderForm01.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "MMANDIA" wrote in message ... I would like to send you my file so you can see what I have. Mike "Jean-Guy" wrote: Hi, Create a table with all the info then use a VLOOKUP function to retrieve the info, so if A1 is your drop down menu then. =VLOOKUP($A$1,your table range,2,0) the 2 in the formula represent the column number in the table, you can replace it with either a COLUMN function or ROW function to make it easier to copy across or down. e.g. =VLOOKUP($A$1,your table range,COLUMN(B1),0) ...copied across =VLOOKUP($A$1,your table range,ROW(A2),0) ....copied down B1 and A2 refers to the second column in the table.... don't forget to make your table range aboslute ($B$1:$F$100) or you can name your table and use that name in the forumula instead. HTH Jean-Guy "MMANDIA" wrote: I have created a basic Work Order with drop downs, worls great. Now I would like to add customers to a worksheet drop down. Once I select the customers name, I would like to fill in address, Phone, Customer ID, etc. in work order to print invoice. I will put all this info into a worksheet in the workbook. How can I do this in Excel. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Multiple cells when choosing one selection from drop
Jean, I will give this a try, If not you will see an email from me...
Thanks for all the help. "Jean-Guy" wrote: Hi, There's really no need, try this and if you can't get it working after then you can send it to me! just open a blank worksheet, in cells F1 to F4 type a few customer names, in cells G1 to G4 type their phone numbers, in cells H1 to H4 their address...in B1 type =VLOOKUP($A$1,$F$1:$G$4,ROW(A2),0) and copy down to B2, now type any customer name from the table to see their info. Regards! Jean-Guy dotcom "MMANDIA" wrote: I would love to email you my file so you can see what I have. "MMANDIA" wrote: I have created a basic Work Order with drop downs, worls great. Now I would like to add customers to a worksheet drop down. Once I select the customers name, I would like to fill in address, Phone, Customer ID, etc. in work order to print invoice. I will put all this info into a worksheet in the workbook. How can I do this in Excel. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Multiple cells when choosing one selection from drop
Jean, I email you a file yesterday... Hoping you received it. I would like
cell not to have to be in a cluster, as you see in CustID. that is my misunderstanding. Thanks again. "Jean-Guy" wrote: Hi, There's really no need, try this and if you can't get it working after then you can send it to me! just open a blank worksheet, in cells F1 to F4 type a few customer names, in cells G1 to G4 type their phone numbers, in cells H1 to H4 their address...in B1 type =VLOOKUP($A$1,$F$1:$G$4,ROW(A2),0) and copy down to B2, now type any customer name from the table to see their info. Regards! Jean-Guy dotcom "MMANDIA" wrote: I would love to email you my file so you can see what I have. "MMANDIA" wrote: I have created a basic Work Order with drop downs, worls great. Now I would like to add customers to a worksheet drop down. Once I select the customers name, I would like to fill in address, Phone, Customer ID, etc. in work order to print invoice. I will put all this info into a worksheet in the workbook. How can I do this in Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Choosing multiple items in a drop down list | Excel Discussion (Misc queries) | |||
Formula to populate a drop down list based on the selection of ano | Excel Discussion (Misc queries) | |||
Auto populate several cells based on a selection from drop down li | Excel Discussion (Misc queries) | |||
Auto Fill Cells, When Choosing From Drop-Down List... | Excel Worksheet Functions | |||
need to populate several cells based on drop down menu selection | Excel Discussion (Misc queries) |