IF Function with VLOOKUP formula

[Gtrtim112]

I'm trying to make an email form that I can use versus the address book in my work email. We have over 1,000 groups and when emailing multiple groups, it's a pain in the rear to select the particular groups from the address book. Instead, I thought I would make a form that would concatenate results and generate the needed email results into an email.

My hangup is getting the IF and VLOOKUP formula to work like I need it to. Basically, I have a user form tab that allows the user to list a single or multiple location (we call them TIDs) numbers in column A. There is a user form to the right where they can select which groups are to receive the email... group1, group 2, group 3, etc.

My thought is that the user will enter the TID numbers as needed, select the group or groups to email and click a generate email button that will display an Outlook email, with all addresses listed. The user can then type the body of the email and send. This would save looking up all those email addresses.

I've attached an example with notes that may make more sense than this message... haha

Can anyone assist with this one? I'm sure it's simple. I just don't understand how to combine the two formulas properly.

[protonLeah]

M3, et al.:

Please Login or Register  to view this content.

groupaddresses ='Data Handling'!$D$3:$J$232
Groups ='User Form'!$E$3:$E$9
Term ='Data Handling'!$A$3:$A$232

[Gtrtim112]

M3, et al.....

Ben... this is perfect! Wow! Awesome job and THANK YOU so much! I really appreciate it!