I am way out of my league on this one.
I am trying to build a form that we (my organization) would like to use to generate a list of email addresses based on a collection of users with various attributes. The form looks like this:
In addition to this sheet, I have created another sheet called "Data" which contains a column for Location, another column representing the service/role and another column representing monitoring level. I have these columns tied to the data validation boxes with a simple TRUE or FALSE (except for location, which is just a dropdown list).
A third sheet contains the actual list of the contacts and their associated email address. I have also created 5 columns to assign appropriate service/role "tags." My thought with the form was if we could select the location that the contact resides, and then select all appropriate checkboxes (tags), that I could use a formula to populate all the contacts that match that criteria in the big box below, thus making a simple list of email addresses that can be copy/pasted into Outlook.
For the life of me, I can't figure out how to do this. I am not sure if vlookup is the right way with an IF statement or if there is something easier, but I have had no luck. Thoughts on how to go about this? Or maybe there is already an app out there that can do this without having to leverage excel? It seems like a simple ask but I haven't found anything.
I am trying to build a form that we (my organization) would like to use to generate a list of email addresses based on a collection of users with various attributes. The form looks like this:
In addition to this sheet, I have created another sheet called "Data" which contains a column for Location, another column representing the service/role and another column representing monitoring level. I have these columns tied to the data validation boxes with a simple TRUE or FALSE (except for location, which is just a dropdown list).
A third sheet contains the actual list of the contacts and their associated email address. I have also created 5 columns to assign appropriate service/role "tags." My thought with the form was if we could select the location that the contact resides, and then select all appropriate checkboxes (tags), that I could use a formula to populate all the contacts that match that criteria in the big box below, thus making a simple list of email addresses that can be copy/pasted into Outlook.
For the life of me, I can't figure out how to do this. I am not sure if vlookup is the right way with an IF statement or if there is something easier, but I have had no luck. Thoughts on how to go about this? Or maybe there is already an app out there that can do this without having to leverage excel? It seems like a simple ask but I haven't found anything.
