Common Text Entries

[MeMe]

If I enter a "company-assigned" number to a cell in column c, for example,
how do I program the company name to appear in column d?

 

[Ron de Bruin]

Hi MeMe

Look at the Vlookup worksheetfunction

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

 

[Anne Troy]

First create a worksheet with company numbers/names (you can do this on
another sheet--even a hidden sheet), then use VLOOKUP. See:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com