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?
Formulas to return words and letters
- Thread starter Wings
- Start date
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- 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.
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.