Private Sub Worksheet_Change(ByVal Target As Range)
If Application.Intersect(Target, Range("A26:A2500")) Is Nothing Then exit sub
If Target <> "" Then
Range("B" & Target.Row) = Application.WorksheetFunction.VLookup(Target, Worksheets("Descro").Range("A1:B2500"), 2, 0)
Else
Range("B" & Target.Row) = ""
End If
End Sub