Ryan, you probably just need a lookup. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com
"sans" wrote in message
...
I've got a column where I insert a contact like NOC-EDS and NOC-WAC. Is it
possible to have the cell adjacent to that column auto-fill those phone
numbers? Or will I need a macro?
Thanks,
Ryan