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