You can use the VLOOKUP function to return data from a table. There are
instructions and examples he

http://www.contextures.com/xlFunctions02.html


Thijs wrote:
i would like to find out whether I can store my contacts' information (names
and Addresses) in Excel, so that it can be self-completing when I am working
on a new worksheet.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html