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