Use the VLOOKUP Function.

You have a table of Account Numbers and Descriptions in two columns, say on a
separate Sheet2 in Columns A and B from row1 to row 50

In A1 of Sheet1 enter an account number.

In B1 of Sheet1 enter this formula =VLOOKUP(A1,Sheet2!$A$1:$B$50,2,FALSE)

The description for account number will show in B1.

For more on VLOOKUP and perhaps Data Validation dropdown lists see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

The DV lists save the typing part.


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 15:56:04 -0800, sweetb
wrote:

I would like to be able to create a formula, so that when I type in a Chart
of Account number in one cell, the description of the account appears in the
next cell.

I've been searching the Microsoft Help site, but no luck...

Anyone??