Auto-fill cell based on adjacent cell information..

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

Ryan, you probably just need a lookup. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"sans" <sans@discussions.microsoft.com> wrote in message
news:2C536BAB-8260-4BF9-BB6D-270074118A4C@microsoft.com...
> 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