If it works for you then nothing.
Note: You might want to fix your range F2:F500 or amend to F:F
Plus if no violations then you would get #N/A so try
=IF(ISNA(VLOOKUP(A3,'Driving Violations'!F:F,1,FALSE)),"",VLOOKUP(A3,'Driving Violations'!F:F,1,FALSE))
VBA Noob
Bookmarks