can I create an "if" formula with an external list?

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

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
 
The Natural replacement for the growing nested IFs is: VLOOKUP.
Study it in Excels help.
Micky
 
Back
Top