#1
|
|||
|
|||
Specific Functions to Use (If this then, that)
Hello,
I'm trying to figure out what is the best function/setup to use if I'm looking to set up the following: Ex: Document that will be used as a guide to refer to documents based off answered Questions: Multiple Questions Yes/No Does the change introduce new air emissions (Yes/No) - Answer to choose from a list of selcted documents that pertain to the choice, the issue will be I will need to ask multiple questions therefor the more questions that are answered the list will be narrowed down to more and more specific required documents? Understand what I'm attempting to get at? Almost like a flowchart but using dropdown questions. |
#2
|
|||
|
|||
It sounds like you're describing multiple dependent dropdown lists.
I've found this page a good basic walk-through on how to think about setting that up. https://www.contextures.com/xldatava...Produce%20Type. Ann |
#3
|
|||
|
|||
Thank you I will check it out!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I transfer specific data from email to specific excel cells? | Mauro | Outlook | 1 | 11-11-2019 09:17 PM |
Linking Specific text fields in PP to specific cells in an Excel table | GWRW1964 | PowerPoint | 0 | 02-26-2018 07:37 AM |
Developer Functions | emmanpelayo | Word VBA | 13 | 07-13-2015 10:36 PM |
Print attachment when it arrive in specific folder with specific subject | visha_1984 | Outlook | 1 | 01-30-2013 10:42 AM |
** Using Functions | djreyrey | Excel Programming | 10 | 02-08-2011 04:18 PM |