Yes you can. Scripts below, I am assuming you want to look for exact matches of ABC or X only and that we don't want to be case sensitive. If we don't want exact matches only "LookAt:=xlWhole" needs to change to "LookAt:=xlPart". If you want to be case sensitive then "MatchCase:=False" needs to be switched to "MatchCase:=True". If you have a header row you want to ignore then
"For iCntr = lRow To 1 Step -1" and "For iCntr = lCol To 1 Step -1" need to change to "... To 2 Step -1".
Dim ws As Worksheet Dim rng As Range Dim targetDate As Range Dim lRow As Long Dim iCntr As Long