Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Return only one result from list with multiple posibilities
Good afternoon
I received assistance with a similar issue, but working through the form creation, I came up with an additional issue. I am creating a form in Excel where a user can go in and select a DIV from a Data Validation List. Based on the selection, the next piece of information, PLAN, is a dependant drop down, and the user can select either N/A if no PLAN exists, or the PLAN they need. What I am attempting to do is have the next piece of information, BILLTO, autopopulate with a Specific piece of information based on the DIV and PLAN being selected. The issue I am running into is I can get the BILLTO to populate with selections based on the DIV, but can not figure out how to get BILLTO to autopopulate based on the DIV and PLAN combination. My issue is the PLAN may apply to multiple DIVs. So to summarize, I want the user to select the DIV and PLAN, then have the BILLTO autopopulate based on the PLAN and DIV combination. Meaning, if the user selects DIV ABC, then they select PLAN 0000000001, The BILLTO would autopopulate ABC, even if the PLAN 0000000001 may apply to other DIVs. If this makes sense, and anyone can direct me in the proper direction, I would greatly appreciate it. If more information is needed, please let me know. Thank you very much in advance for any assistance. Mathew G |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
Quote:
Thank You Mathew |
#4
|
|||
|
|||
Quote:
Thank you Mathew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Lookup return 1 result | Excel Discussion (Misc queries) | |||
return a result from multiple conditions. | Excel Worksheet Functions | |||
Subject: return a result from multiple conditions. | Excel Worksheet Functions | |||
lookup for a value in multiple columns and return a result | Excel Discussion (Misc queries) | |||
Return result from multiple criteria | Excel Worksheet Functions |