Results 1 to 9 of 9

How to generate a LIST from codes

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2009
    Location
    New Delhi
    MS-Off Ver
    Excel 2007
    Posts
    41

    How to generate a LIST from codes

    Hi, I work on Excel 2003 and XP-SP2 operating system. I have approx 26 error types (say from A-Z), like :
    Code------- Description
    A ----------- No address
    B ----------- No account
    C ----------- No name, etc etc.

    I would like to input the error code in a cell, and get the description in the adjoining cell, one beneath the other. E.g. if I type only C in cell A1, then the output in cell B1 should be No Name.

    However, if I type ABC in cell A2, then output in cell B2 should look like :
    No address
    No account
    No name

    I checked lots of posts but could not find the answer, so if anyone can help me with this, I will be very grateful. thanks in advance....b
    Last edited by bitswit; 08-21-2010 at 05:26 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1