Hi sweetb

Have a look at creating a VLOOKUP table.
A search on here or the help page will give you thousands of examples.

HTH
Michael M

"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??