software

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 quot;Emailquot; directly next to quot;Employeequot; in my DV
sheet. Would this be an quot;IFquot; function or is there an easier way since its not
multiple columns of info? I have looked at Contextures.com and don't see
quot;simplequot; 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)quot;cjtj4700quot; gt; wrote in message
...
gt; Hi~
gt; Simple. When a user selects their name from my DV dropdown list located at
gt; F11, I want their email address to auto populate in F14. I have added a
gt; dynamic named range called quot;Emailquot; directly next to quot;Employeequot; in my DV
gt; sheet. Would this be an quot;IFquot; function or is there an easier way since its
not
gt; multiple columns of info? I have looked at Contextures.com and don't see
gt; quot;simplequot; examples like this. Please S_P_E_L_L it out for me when replying
on
gt; how I can do this.
gt;
gt; Thx
I wish it was self-explanatory. When I go to the add a function tool, INDEX
lists 4 boxes: Ref, row, column amp; 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 quot;as isquot;?

Thx

quot;Bob Phillipsquot; wrote:

gt; =INDEX(email_range,MATCH(F11,employee_range,0)
gt;
gt; hopefully that is self-explanatory.
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt; (remove nothere from the email address if mailing direct)
gt;
gt;
gt; quot;cjtj4700quot; gt; wrote in message
gt; ...
gt; gt; Hi~
gt; gt; Simple. When a user selects their name from my DV dropdown list located at
gt; gt; F11, I want their email address to auto populate in F14. I have added a
gt; gt; dynamic named range called quot;Emailquot; directly next to quot;Employeequot; in my DV
gt; gt; sheet. Would this be an quot;IFquot; function or is there an easier way since its
gt; not
gt; gt; multiple columns of info? I have looked at Contextures.com and don't see
gt; gt; quot;simplequot; examples like this. Please S_P_E_L_L it out for me when replying
gt; on
gt; gt; how I can do this.
gt; gt;
gt; gt; Thx
gt;
gt;
gt;

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)quot;cjtj4700quot; gt; wrote in message
...
gt; I wish it was self-explanatory. When I go to the add a function tool,
INDEX
gt; lists 4 boxes: Ref, row, column amp; area. I don't have a clue what I need to
gt; enter into each. Is there a way to simply take your formula below and
insert
gt; it quot;as isquot;?
gt;
gt; Thx
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; =INDEX(email_range,MATCH(F11,employee_range,0)
gt; gt;
gt; gt; hopefully that is self-explanatory.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; RP
gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;
gt; gt;
gt; gt; quot;cjtj4700quot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi~
gt; gt; gt; Simple. When a user selects their name from my DV dropdown list
located at
gt; gt; gt; F11, I want their email address to auto populate in F14. I have added
a
gt; gt; gt; dynamic named range called quot;Emailquot; directly next to quot;Employeequot; in my
DV
gt; gt; gt; sheet. Would this be an quot;IFquot; function or is there an easier way since
its
gt; gt; not
gt; gt; gt; multiple columns of info? I have looked at Contextures.com and don't
see
gt; gt; gt; quot;simplequot; examples like this. Please S_P_E_L_L it out for me when
replying
gt; gt; on
gt; gt; gt; how I can do this.
gt; gt; gt;
gt; gt; gt; Thx
gt; gt;
gt; gt;
gt; gt;
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 Goviercjtj4700 wrote:
gt; I wish it was self-explanatory. When I go to the add a function tool, INDEX
gt; lists 4 boxes: Ref, row, column amp; area. I don't have a clue what I need to
gt; enter into each. Is there a way to simply take your formula below and insert
gt; it quot;as isquot;?
gt;
gt; Thx
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt;
gt;gt;=INDEX(email_range,MATCH(F11,employee_range,0)
gt;gt;
gt;gt;hopefully that is self-explanatory.
gt;gt;
gt;gt;--
gt;gt;
gt;gt;HTH
gt;gt;
gt;gt;RP
gt;gt;(remove nothere from the email address if mailing direct)
gt;gt;
gt;gt;
gt;gt;quot;cjtj4700quot; gt; wrote in message
...
gt;gt;
gt;gt;gt;Hi~
gt;gt;gt;Simple. When a user selects their name from my DV dropdown list located at
gt;gt;gt;F11, I want their email address to auto populate in F14. I have added a
gt;gt;gt;dynamic named range called quot;Emailquot; directly next to quot;Employeequot; in my DV
gt;gt;gt;sheet. Would this be an quot;IFquot; function or is there an easier way since its
gt;gt;
gt;gt;not
gt;gt;
gt;gt;gt;multiple columns of info? I have looked at Contextures.com and don't see
gt;gt;gt;quot;simplequot; examples like this. Please S_P_E_L_L it out for me when replying
gt;gt;
gt;gt;on
gt;gt;
gt;gt;gt;how I can do this.
gt;gt;gt;
gt;gt;gt;Thx
gt;gt;
gt;gt;
gt;gt;

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!

quot;Roger Govierquot; wrote:

gt; Hi
gt;
gt; Supposing your data list for employees is Sheet2!$A$1:$A$100
gt; and your list for Emails is Sheet2!$B$1:$B$100, then what Bob is suggesting,
gt; is that you put in cell F14
gt;
gt; =INDEX(Sheet2!$B$1:$B$100,MATCH(F11,Sheet2!$A$1:$A $100,0))
gt;
gt; This will find the position in the list of Employee names for the name
gt; selected in cell F11, and find the equivalent position down the list of
gt; email addresses.
gt; Change the ranges to suit where you have your lists of Employees and Emails
gt; stored.
gt;
gt;
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; cjtj4700 wrote:
gt; gt; I wish it was self-explanatory. When I go to the add a function tool, INDEX
gt; gt; lists 4 boxes: Ref, row, column amp; area. I don't have a clue what I need to
gt; gt; enter into each. Is there a way to simply take your formula below and insert
gt; gt; it quot;as isquot;?
gt; gt;
gt; gt; Thx
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;=INDEX(email_range,MATCH(F11,employee_range,0)
gt; gt;gt;
gt; gt;gt;hopefully that is self-explanatory.
gt; gt;gt;
gt; gt;gt;--
gt; gt;gt;
gt; gt;gt;HTH
gt; gt;gt;
gt; gt;gt;RP
gt; gt;gt;(remove nothere from the email address if mailing direct)
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;quot;cjtj4700quot; gt; wrote in message
gt; ...
gt; gt;gt;
gt; gt;gt;gt;Hi~
gt; gt;gt;gt;Simple. When a user selects their name from my DV dropdown list located at
gt; gt;gt;gt;F11, I want their email address to auto populate in F14. I have added a
gt; gt;gt;gt;dynamic named range called quot;Emailquot; directly next to quot;Employeequot; in my DV
gt; gt;gt;gt;sheet. Would this be an quot;IFquot; function or is there an easier way since its
gt; gt;gt;
gt; gt;gt;not
gt; gt;gt;
gt; gt;gt;gt;multiple columns of info? I have looked at Contextures.com and don't see
gt; gt;gt;gt;quot;simplequot; examples like this. Please S_P_E_L_L it out for me when replying
gt; gt;gt;
gt; gt;gt;on
gt; gt;gt;
gt; gt;gt;gt;how I can do this.
gt; gt;gt;gt;
gt; gt;gt;gt;Thx
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;