Formula question for multiple outputs

[kernownelly]

Hi everyone it has been a long time since creating a spreadsheet and well my for.ula knowledge has gone. I am looking for help for a formula to aid with some data input.
Is it possible to create a formula for the following:
If "a" is inputted then display "x" but this for a range of 6 possible inputs (ranging for example a - f) displaying one of a possible 6 words.
For example if I typed c I to a cell then friday would be displayed and if d was typed then sunday displayed.
Just to make data input easier than typing the words in using a lettered system

Hope makes sense.

Thanks in advance

 

[Kerryx]

something like this maybe

Book1
	A	B	C	D	E
2	a	sa		a	sa
3				b	su
4				c	mo
5				d	tu
Sheet1

Cell Formulas
Range	Formula
B2	B2	=FILTER(E2:E5,D2:D5=A2,)

 

[Eric W]

For older versions of Excel (like 2011):

Book1
	A	B	C	D	E
1
2	a	sa		a	sa
3				b	su
4				c	mo
5				d	tu
Sheet8

Cell Formulas
Range	Formula
B2	B2	=VLOOKUP(A2,$D$2:$E$5,2,0)

Also, depending on what you have in mind, you could add your words to AutoCorrect. Click on File>Options>Proofing>AutoCorrect Options, and add your before and after conversion words. I wouldn't recommend it for single letters though.

 

[PeteWright]

If you wouldn't mid using VBA you could place the following code in the Workbook Section in the VBA Editor.
Press [Alt]+[F11] to bring up the VBA Editor.

Private Sub Worksheet_Change(ByVal Target As Range)
   Application.EnableEvents = False
   'Code that modifies cells
   If Target.Count = 1 Then
      Select Case Target
         Case "a"
            Target = "Monday"
         Case "b"
            Target = "Tuesday"
         Case "c"
            Target = "Wednesday"
         Case "d"
            Target = "Thursday"
         Case "e"
            Target = "Friday"
         Case "f"
            Target = "Saturday"
         Case Else
            GoTo EndOfSub
      End Select
   End If
EndOfSub:
   Application.EnableEvents = True
End Sub

But as @Eric W mentioned it is not recommended with single letters.

Instead I would add a suffix like a period (e.g. "a." becomes "Monday" etc.)