There is no formula to do that... but you can use VBA.
right click on the sheet tab and select View Code.
paste the following code in the editor.
now select an item in C1:C14 range and B1 should change accordingly.Code:Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target.Cells, Range("C1:C14")) Is Nothing Then Exit Sub Target.Offset(0, -1) = Target.Value End Sub
Bookmarks