Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlook to generate a drop down menu
What I am trying to do is you type in the customer's name which generates the
mailing address using V look (let say from the customers data base ) But what I want to do is from the customer look up I want to be able to have let say the column with that particular customers contacts be a drop down menu and once you choose the contact again through V look up it will generate the phone, fax and email. I know how to do the lookups just not sure how to handle the drop down menu -- Donna |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlook to generate a drop down menu
If I understand correctly, you want the drop downs to contain the customer
names. Those names are also somewhere in a table that you use for the VLOOKUP(). Perhaps on another sheet even. Dropdowns are usually done using Data Validation (Data menu, Validation option). It needs a list of cells containing the items to be in the list as a parameter. Normally those have to be on the same sheet with the validated cells. But we can get around that using Named Ranges. Here's how: Go to the sheet with the list of customers on it. Select all of the Customer's names, plus perhaps 1 empty row at the bottom of it - I'll tell you why later. Now up in the upper left corner where it shows you the address of the cell you have selected type in a name for this list and press the [Enter] key. Let's call it CustomersList. Now that range of entries can be referenced in this workbook by that name. I said to choose 1 blank row at the end. You really didn't have to, but if you add entries to the list, you will need to INSERT new rows within the existing named range so that the new entries will remain part of that named range. By having that extra blank row, you can go to it, use Insert - Row and make an entry and it'll still be part of the list. OK, now back to the cells that need Data Validation. Choose them, either one at a time, or as a group and use Data -- Validation and choose[list] in the type of data to "Allow" and where it asks for Source type in =CustomersList and click OK. Now your drop downs will have the customer names in it, which helps assure matches for the VLOOKUP() done to get the rest of the information. Hope this helps. "Tacklemom" wrote: What I am trying to do is you type in the customer's name which generates the mailing address using V look (let say from the customers data base ) But what I want to do is from the customer look up I want to be able to have let say the column with that particular customers contacts be a drop down menu and once you choose the contact again through V look up it will generate the phone, fax and email. I know how to do the lookups just not sure how to handle the drop down menu -- Donna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
using two drop downs with a vlook up formula | Excel Worksheet Functions | |||
generate a menu list | Excel Discussion (Misc queries) | |||
How do I use drop down list selections/values in a vlook up formu. | Excel Discussion (Misc queries) |