Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link text/data in Excel 2007 ?
Need some help with linking in Excel 2007
The yellow text is a drop-down list that's linked to the name Christer Johansson. But I also want to link the name to a specific email or regular adress. When you choose a name in the drop-down list, the emailadress will appear in a different column and will be changed when you change the name in the list. I hope you understand my problems. Attached a link to a print screen. http://img513.imageshack.us/i/excel2007.jpg/ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link text/data in Excel 2007 ?
Hi Ken
Assuming you have a list of Data on Sheet2 with Name in column A and Email address in column B On your sheet with the dropdown, assuming your dropdown is in Shet1 cell A2, enter in B2 =IF($A2="","",VLOOKUP($A2,Sheet2!$A:$B,2,0)) -- ------- Regards Roger Govier "KenZu" wrote in message ... Need some help with linking in Excel 2007 The yellow text is a drop-down list that's linked to the name Christer Johansson. But I also want to link the name to a specific email or regular adress. When you choose a name in the drop-down list, the emailadress will appear in a different column and will be changed when you change the name in the list. I hope you understand my problems. Attached a link to a print screen. http://img513.imageshack.us/i/excel2007.jpg/ __________ Information from ESET Smart Security, version of virus signature database 4873 (20100217) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4873 (20100217) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link text/data in Excel 2007 ?
It didnt work. I got all my info in same sheet. if thats the problem. Tried
to change the script from sheet2 - sheet1 but with no success. I dont know, but my excel version is in Swedish, if that could be the problem. / KenZu "Roger Govier" skrev: Hi Ken Assuming you have a list of Data on Sheet2 with Name in column A and Email address in column B On your sheet with the dropdown, assuming your dropdown is in Shet1 cell A2, enter in B2 =IF($A2="","",VLOOKUP($A2,Sheet2!$A:$B,2,0)) -- ------- Regards Roger Govier "KenZu" wrote in message ... Need some help with linking in Excel 2007 The yellow text is a drop-down list that's linked to the name Christer Johansson. But I also want to link the name to a specific email or regular adress. When you choose a name in the drop-down list, the emailadress will appear in a different column and will be changed when you change the name in the list. I hope you understand my problems. Attached a link to a print screen. http://img513.imageshack.us/i/excel2007.jpg/ __________ Information from ESET Smart Security, version of virus signature database 4873 (20100217) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4873 (20100217) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 data link update prompt | Links and Linking in Excel | |||
Link updates Excel 2007 | Excel Worksheet Functions | |||
how do I link a text box on a chart to a specific data point? | Charts and Charting in Excel | |||
Link Macros Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Beta 2 Error -- Text-to-Columns Wizard Data preview wha | Excel Discussion (Misc queries) |