Results 1 to 3 of 3

Thread: Need help! "Data-validation-Like' formula??

  1. #1

    Need help! "Data-validation-Like' formula??



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Is there a way through data validation or lookups to do this:

    Say we 15 things that can apply to one item. Is there a formula I could use to enter codes of those things into one cell and have the actual descriptions being populated in the next column?

    Column A (just text): lemon
    Column B (enter descriptors; codes): 1;3;5;8
    Column C (the corresponding desciptors appear): yellow; citrus; vitamin C; tree

    Data Validation descriptors:

    1 yellow
    2 red
    3 citrus
    4 vegetable
    5 vitamin C
    6 Vitamin D
    7 root
    8 tree
    Many thanks in advance,
    T

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,462
    Articles
    0
    Excel Version
    2010 on Xubuntu

  3. #3
    Are you basically trying to have someone input a number in one field and then it will display text in another field based off of the values you set?

Tags for this Thread

Posting Permissions

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