I tried your equation and a box poped up that looked like the box when you click save as. Im not sure what to do with it.

but basically this is what I need:
=COUNT(VLOOKUP(A6,DrivingViolations!F:F,1))