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?