Can someone tell me where im going wrong with the below code, i tried it in two parts so adding the value of the formula works but when i add the if, the whole section of code doesnt seem to work, i know it must be syntax issue but dont know where??
LastTableCell = Cells(Rows.Count, "A").End(xlUp).Row
For Each Cell In Range("E2:E" & LastTableCell)
Cell.FormulaR1C1 = _
"=IF(ISERROR(VLOOKUP(RC[-4],'[TECHTM.xlsx]MASTER TECH LIST'!R2C1:R392C5,5,0)),""UNKNOWN"",VLOOKUP(RC[-4],'[TECHTM.xlsx]MASTER TECH LIST'!R2C1:R392C5,5,0))"
Cell.Value = Cell.Value
If Cell.Value <> "COMEX" Then
Cell.EntireRow.Delete
End If
Next Cell
Bookmarks