If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic | Harlan Grove | General Discussion | 3 | November 14th, 2005 10:58 PM |
Visual Basic Error | Jon Newsom | General Discussions | 2 | November 2nd, 2005 07:49 PM |
VB6 and Visio 2003 | Visio | 6 | August 25th, 2005 01:22 PM | |
Difference between Visio Visual Basic and visual Basic | Daniell | Visio | 1 | October 21st, 2004 09:07 PM |
Missing help entries in Visual Basic (Office 2003) | XLed | General Discussions | 0 | May 22nd, 2004 07:33 AM |