Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I display records using a key field in Excel?
I have an excel spreadsheet of customers. I also created a form that
contains a "list box" to display customer name. By selecting a customer, I want to be able display certain fields (address, cust no.) from my customers record in my excel spreadsheet list. How do I go about it? |
#2
|
|||
|
|||
To return the discount for the selected customer, you can use a VLookup
formula. There are instructions and examples he http://www.contextures.com/xlFunctions02.html There's a sample file that uses Data Validation and VLookup formulas he http://www.contextures.com/excelfiles.html#Function Under Data Validation, look for 'Order Form' Vic from Texas wrote: I have an excel spreadsheet of customers. I also created a form that contains a "list box" to display customer name. By selecting a customer, I want to be able display certain fields (address, cust no.) from my customers record in my excel spreadsheet list. How do I go about it? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
Pivot Tables..I give up... | Excel Worksheet Functions | |||
Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |