Auto-fill cell based on adjacent cell information..

's Computer Specifications

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

's Computer Specifications

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

"sans" <(E-Mail Removed)> wrote in message
news:2C536BAB-8260-4BF9-BB6D-(E-Mail Removed)...
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto Fill Cell Based on Data in a different cell	JB Bates	Microsoft Excel Misc	4	15th Oct 2009 04:17 PM
AUTO FILL ADJACENT CELL WITH SPECIFIED VALUE	Sinner	Microsoft Excel Programming	2	20th Dec 2008 02:15 PM
Auto fill cell based upon another cell value	Shek5150	Microsoft Excel Misc	3	3rd Nov 2008 03:28 PM
Auto colour based on adjacent cell	crapit	Microsoft Excel Discussion	5	13th Sep 2008 04:14 PM
Inputting cell value from source cell based on value in adjacent cell.	michaelberrier	Microsoft Excel Misc	3	9th Dec 2006 09:16 PM