Results 1 to 2 of 2

Thread: Formulas to return words and letters

  1. #1
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    29
    Articles
    0
    Excel Version
    2013

    Formulas to return words and letters



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

    Hello, can someone help me how to write a formula that will return some writing, if one was to put A in the cell it would return one lot of text, if B another lot an so on for a whole lot of different possible text options. =IF(And( or how would the string look?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    You would create a table on the side of all possible inputs vs. the corresponding outputs. Then you could use VLOOKUP()

    e.g.

    =VLOOKUP(A2,$X$2:$Y$10,2,FALSE)

    This will look up the entry you made in cell A2 and find it in the first column of range X2:Y10. If it finds it, then it will pull the corresponding string from column Y in the table and return the result where you entered your formula.


Posting Permissions

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