VBA Vlookup

Hi

I have having a slight problem with an offset.

As part of a Case statement, I have the following code:

Select Case Target.Column
Case 1
If Target.Column = 1 Then
If Len(Target) Then
Target.Offset(, 4).Value = Date
cell.Offset(, 5).Value = WorksheetFunction.Vlookup(Target, Sheets("ITFC Returns").Range("B:C"), 2, False)
cell.Offset(, 5).Value = WorksheetFunction.Vlookup(Target, Sheets("LML Returns").Range("B:C"), 2, False)
If cell.Offset(, 5).Value = "ITFC" Then
cell.Offset(, 7).Value = Date

End If
If cell.Offset(, 5).Value = "LML" Then
cell.Offset(, 7).Value = Date
End If
If cell.Offset(, 5).Value = "" Then
cell.Offset(, 5).Value = "IN CHISWICK"
cell.Offset(, 7).Value = Date
End If
Else
cell.Offset(, 4).Value = ""
cell.Offset(, 5).Value = ""

End If
End If


My problem is that it is not actually activating the vlookup formula at all without me pressing F2 and enter in the cell in column A. I'm sure that there is an easy fix to this.

My other issue is that the VLookup is not working like a formula and not always active, ie if the lookup value is deleted from the lookup location, it does not update where the lookup result goes.

Would you be able to help me make the vlookup always active so that it is always looking for an answer?

I would greatly appreciate your assistance with the above

Many thanks

Miles