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

Auto-fill cell based on adjacent cell information..
 

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