Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Multiple Part question:
Created an Invoice with various cells. There is a Customer Name, Address, City, State, Zip and Phone Number. I've created a separate worksheet that contains the Customer information. I created a Drop Down Box on the Invoice. Created a VLOOKUP for the Address, City, State, Zip and phone number Cells. =VLOOKUP(D12,CUSTOMER!A2:F6,2,TRUE) Question 1: The 1st few records work perfectly. 1. I choose the Customer from the drop down list and the remaining fields self-complete. 2. There are several records that won't populate. They show on the drop down but none of the fields populate when you choose the customer. 3. I have verified there is data in the VLOOKUP fields Any suggestions would be great. Question 2: How do I make the Customer Field be empty until I choose the drop down arrow. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Want use results of Drop down list to look up a value | Excel Discussion (Misc queries) | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
Concatenate Results from a Validated Drop Down List | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
How can I list the results of my macro without overwritng previous results? | Excel Programming |