I'm doing an extract from our system & can only extract a 2 digit code.
There is a description that goes along with the code, but I'm not able to
pull that part out, so I need to duplicate it in Excel. Example - type of
account is defined by a 2 digit number--

41 revocable
43 irrevocable
61 agency

I need to add a column to insert a description that matches up with the
code. In the past I've used an IF function, but because these can change, it
would be easier to maintain a separate list & add the description based on
the lst.

Is this possible?

Suppose your separate list of codes and corresponding descriptions
occupies columns A and B of Sheet2, and suppose that the codes that
you have extracted are in column C of Sheet1. Put this in D1 of
Sheet1:

=VLOOKUP(C1,Sheet2!A:B,2,0)

and copy this down as far as you need to.

Hope this helps.

Pete



On Dec 8, 7:09*pm, jason wrote:
I'm doing an extract from our system & can only extract a 2 digit code. *
There is a description that goes along with the code, but I'm not able to
pull that part out, so I need to duplicate it in Excel. *Example - type of
account is defined by a 2 digit number--

41 *revocable
43 irrevocable
61 agency

I need to add a column to insert a description that matches up with the
code. *In the past I've used an IF function, but because these can change, it
would be easier to maintain a separate list & add the description based on
the lst.

Is this possible?

The Natural replacement for the growing nested IFs is: VLOOKUP.
Study it in Excels help.
Micky


"jason" wrote:

I'm doing an extract from our system & can only extract a 2 digit code.
There is a description that goes along with the code, but I'm not able to
pull that part out, so I need to duplicate it in Excel. Example - type of
account is defined by a 2 digit number--

41 revocable
43 irrevocable
61 agency

I need to add a column to insert a description that matches up with the
code. In the past I've used an IF function, but because these can change, it
would be easier to maintain a separate list & add the description based on
the lst.

Is this possible?