Setting up a formula HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Setup a table with your names and email addresses in it. For example:

Starting in column Y, enter all of your names.
In Column Z, enter the appropriate email address next to each name.

Sort both columns (alphabetically ascending order) by column Y.

Then use a VLOOKUP function.

If your name to return an email address is in A1, enter this formula in B1.

=VLOOKUP(A1,Y:Z,2)

HTH,
Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA 1
Set non-continuous PrintArea via Function / Name 0
Lookup Formula 2
Excel help separating / 2
Create a formula by joining text and the value from a formula 3
Hyperlink Formula Problem 2
How do I reference a worksheet name through a formula? 3

Back
Top