I currently have an excel sheet with a button, when pressed it saves and
asked to select email addresses from another worksheet, when the user selects
the email addresses it will then email the relevant people to say this PIP is
ready for review.

Ideally, i would like to reference whatever is in E10 to lookup a
distribution group.

For example if the user types CURWEN into cell E10 it will look up Curwen
from a table within Excel and email whoever exists in the range of curwen.
This would be so much easier. Please help.

Thanks.