Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Valadation
I am using data validation and this is working. But, now I have one more
thing to do question. I want the Phone number to pop up in another area on the form. I assume that I have to put the phone number in a separate column. Example: I have a customer number I use to match and it pulls up the 3 Ship To Address that works just fine, but after I choose the address if I want the phone number associated with the Ship To address I have chosen to show up a few lines down and not pop up the phone number for all 3 Ship To Address is that possible? Right now I use the same customer Id for all related Ship To address for this one customer. I know that if I use a different code like W224A = SHIP TO ADDRESS 1 W224B = SHIP TO ADDRESS 1 W224C = SHIP TO ADDRESS 1 This would work and pop up the phone number associated with each Ship To Address for each code but however I want the display to be W224 and not show W224A, W224B, ETC. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Valadation
How are you choosing a specific address? Is each address unique in the
source data? If so, you could use a VLookup formula to pull the phone number for the selected address. For example, if shipping address is in column B and phone is in column D: =VLOOKUP(J7,B2:D100,3,0) klafert wrote: I am using data validation and this is working. But, now I have one more thing to do question. I want the Phone number to pop up in another area on the form. I assume that I have to put the phone number in a separate column. Example: I have a customer number I use to match and it pulls up the 3 Ship To Address that works just fine, but after I choose the address if I want the phone number associated with the Ship To address I have chosen to show up a few lines down and not pop up the phone number for all 3 Ship To Address is that possible? Right now I use the same customer Id for all related Ship To address for this one customer. I know that if I use a different code like W224A = SHIP TO ADDRESS 1 W224B = SHIP TO ADDRESS 1 W224C = SHIP TO ADDRESS 1 This would work and pop up the phone number associated with each Ship To Address for each code but however I want the display to be W224 and not show W224A, W224B, ETC. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Valadation
Hi,
To reiterate Debra's question - when you pick a Customer # how does Excel know which one of the three ship to addresses to use? -- If this helps, please click the Yes button Cheers, Shane Devenshire "klafert" wrote: I am using data validation and this is working. But, now I have one more thing to do question. I want the Phone number to pop up in another area on the form. I assume that I have to put the phone number in a separate column. Example: I have a customer number I use to match and it pulls up the 3 Ship To Address that works just fine, but after I choose the address if I want the phone number associated with the Ship To address I have chosen to show up a few lines down and not pop up the phone number for all 3 Ship To Address is that possible? Right now I use the same customer Id for all related Ship To address for this one customer. I know that if I use a different code like W224A = SHIP TO ADDRESS 1 W224B = SHIP TO ADDRESS 1 W224C = SHIP TO ADDRESS 1 This would work and pop up the phone number associated with each Ship To Address for each code but however I want the display to be W224 and not show W224A, W224B, ETC. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Valadation | Excel Worksheet Functions | |||
Data Valadation | Excel Discussion (Misc queries) | |||
Using a Hyperlink with Data Valadation | Excel Discussion (Misc queries) | |||
Data Valadation - | Excel Worksheet Functions | |||
Data Valadation help | Excel Worksheet Functions |