DV basic help
 

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

DV basic help
 

=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

DV basic help
 

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

DV basic help
 

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)


"cjtj4700" wrote in message
...
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

DV basic help
 

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

DV basic help
 

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!

"Roger Govier" wrote:

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