Hi

Supposing your data list for employees is Sheet2!$A$1:$A$100
and your list for Emails is Sheet2!$B$1:$B$100, then what Bob is suggesting,
is that you put in cell F14

=INDEX(Sheet2!$B$1:$B$100,MATCH(F11,Sheet2!$A$1:$A $100,0))

This will find the position in the list of Employee names for the name
selected in cell F11, and find the equivalent position down the list of
email addresses.
Change the ranges to suit where you have your lists of Employees and Emails
stored.


Regards

Roger Govier


cjtj4700 wrote:
I wish it was self-explanatory. When I go to the add a function tool, INDEX
lists 4 boxes: Ref, row, column & area. I don't have a clue what I need to
enter into each. Is there a way to simply take your formula below and insert
it "as is"?

Thx

"Bob Phillips" wrote:


=INDEX(email_range,MATCH(F11,employee_range,0)

hopefully that is self-explanatory.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cjtj4700" wrote in message
...

Hi~
Simple. When a user selects their name from my DV dropdown list located at
F11, I want their email address to auto populate in F14. I have added a
dynamic named range called "Email" directly next to "Employee" in my DV
sheet. Would this be an "IF" function or is there an easier way since its

not

multiple columns of info? I have looked at Contextures.com and don't see
"simple" examples like this. Please S_P_E_L_L it out for me when replying

on

how I can do this.

Thx