View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason Jason is offline
external usenet poster
 
Posts: 367
Default can I create an "if" formula with an external list?

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?