You can use this code
or this![]()
If Left(Range("A13"), 4) = "Ford" Then [B13] = "Y"
![]()
Selection.Find(What:="ford*", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate
Bookmarks