I have a cell that can have more than 7 names in it. I would like another
cell (in the same row) to read that cell and return a specific email address
based on the name. I had it working with a rather long winded IF statement,
but we have more than 7 possible names. Is there another approach I should
take? These email addresses will be used by VBA to send out email reminders
to the people identified.