Vlookup, concatenate and buttons

[sderooy]

Hi All, I am a relative novice to Excel, though know how to use basic VLOOKUP. Appreciate any help you can provide. What I am trying to do is automate an email distribution per the example below using buttons. Say I need to send an email to groups B and D, then I would like to click on button B and D and have the cell labeled 'OUTPUT' automatically populated with all the email addresses separated by 'semicolon and a space' There is also an added complication with B and D since 'cuttysark' is found twice, can the formula remove duplicates? So the questions are 1. how do I create buttons? 2. how do I allow the buttons to execute a query like the one above? A whitehorse@google.com <tbody> </tbody> B johnniewalker@google.com <tbody> </tbody> jimbeam@google.com <tbody> </tbody> cuttysark@google.com <tbody> </tbody> jeremiahweed@google.com <tbody> </tbody> C chivasregal@google.com <tbody> </tbody> wildturkey@google.com <tbody> </tbody> D glenmorangie@google.com <tbody> </tbody> jackdaniels@google.com <tbody> </tbody> glenfiddich@google.com <tbody> </tbody> cuttysark@google.com OUTPUT <tbody> </tbody>

<tbody>
</tbody>

Many thanks