Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 1 And Target.Row > 1 Then
On Error Resume Next
Target = Application.WorksheetFunction.VLookup(Target, Sheets(2).Range("A2:B5"), 2, 0)
End If
End Sub