I have a small problem with a VLookup macro.
I want to put the result for that formula in column N of active cell.
But it leaves the cell empty all the time.
Here is the macro in my
Private Sub Worksheet_Change(ByVal Target As Range)
Dim QW As Range
Set QW = Intersect(Target, Range("S6:S" & Rows.Count))
If Not QW Is Nothing Then
If QW.Value > "" Then
QW.Offset(, -5).Formula = "=IF(ISNA(VLOOKUP(QW.Value,'Rate Group'!K:L,1,0))"
QW.Offset(, -5).Value = ""
Can you please help me?