Hi,

You need to set up a lookup table with the codes in the first column and the
descriptions in the second column. Suppose you put this table in K1:L100,
and you enter your code into A1 then the formula in B1 would be

=VLOOKUP(A1,$K$1:$L$100,2,FALSE)

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"GirlFridayCA" wrote:

I am adding columns to an extensive worksheet (3300 rows of data) and need
to know how to format Columns A & B so that when I type in the Code Number
into the cell of Column A, Excel will automatically enter the correlating
description in Column B.

There are approximately 75 Codes with their corresponding descriptions that
will need to be added to the Excel Worksheet new fields (columns).

What formula would I use and how and where would I set up the reference
information to enable Excel to achieve my goal? I have a separate WORD
document with the Codes and Descriptions set up in a table that I could use,
convert or manipulate into something that would be most compatible or
effective.
--
Cali Gal
Native of Sacramento