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

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

Thanks, now that the columns have been filled - how can I make sure the
descriptions in Column B are then locked so that when the worksheet is then
used to merge into an even larger national worksheet without running into
errors? The national large worksheet won't have the lookup table.
--
Cali Gal
Native of Sacramento


"Shane Devenshire" wrote:

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