I have the next use of case:
I have a table in excel and a one field of this table is populated from another table through vlookup. As this vlookup is updated because the responsible guy two years ago is not the same as now. I would like that:

As soon as a new row is inserted in the table, maybe the column id goes from blank to get any number, a specific field takes the value from a lookup table and then paste value (ignoring the formula) to avoid issues when the other table is updated with information valid form now on.

If that approach is not possible maybe the criteria can be for example: if column d is not balnk but column e is blank apply the vlookup and paste results to each cell with that condition.

I am somehow new to macros and I am not confortable yet. I found this on the web:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A2:A100")) Is Nothing Then
Call TestEvent
End If
End Sub

but then I do not know how in the macro TestEvent apply the vlookup and paste value dinamically only in the specific column of the specific row that has been updated

Many thanks in advance