Hi, can someone revise my code below to also include NE to "yes" (lower case). Right now it only works with yes in upper case. Thanks
VBA Code:
On Error Resume Next
If Evaluate("=VLOOKUP(FINALORDER!D4,DEALERLIST!$A$3:$O$1200,15,FALSE)") <> "YES" Then
Exit Sub
End If