Clear cell contents based on offset of dropdown selection on another tab.

Ive got this code, which moves the offset of a selection from a cells drop downlist to another tab:

Private Sub Worksheet_Change(ByVal Target As Range)


If Target.Value Like "Moved to last planner" Then

Sheets("Last Planner").Range("A:A").Find("").End(xlUp).Offset(1, 0) = Target.Offset(0, 2 - Target.Column()).Value
Else
If Target.Value <> "Moved to last planner" Then
End If
End If
End Sub

But I can't figure out how to do the opposite - CLEAR the cell on the Last Planner tab if it matches the offset value of the selected cells dropdown list. Instead of "Moved to last planner" the cell choice that would activate the removal would be "Not Implemented". Somehow I need to compare the offset value from one tab to the range of values in a column in another tab - if it finds it, it clears it.