| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Menu AutoPopulate Contact Info?
Use VLOOKUP or INDEX/MATCH
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm http://www.ozgrid.com/Excel/left-lookup.htm -- Regards Dave Hawley www.ozgrid.com "Clay H" <Clay wrote in message ... I have a template for filling out quotes and I was looking to create a drop down menu with all of the names of customers that I regularly send out quotes to (it's about 20 people). I have figured out how to make a drop down list with a bunch of names but I would like it so that when I select a name from the drop down menu, the customers contact info pops up on the quote under the name. Is this even possible? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down menu w/ info in other columns | Excel Worksheet Functions | |||
| Drop down menu with emp name then autopopulate with supervisor... | Excel Discussion (Misc queries) | |||
| How do I get info from one sheet to autopopulate into all sheets? | Excel Discussion (Misc queries) | |||
| Pivot tables hide info drop down menu | Excel Worksheet Functions | |||
| link drop down menu to info in worksheet | New Users to Excel | |||
Threaded Mode
