DV basic help

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

Guest

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
 
=INDEX(email_range,MATCH(F11,employee_range,0)

hopefully that is self-explanatory.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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
 
Forget the function wizard, just select cell F14, and type that formula into
the formula bar. Change email_range to the range of cells where you have the
email addresses, and employee_range to the range of cells where you have the
employee names.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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
 
Whooppee! Sorry for the hand holding! Works like a dream.

Between Gord, Roger, Bob, Debra et al....I will become an MVP yet!

LOL right?!

Thank you very much!
 
Back
Top