=VLOOKUP(A3,'Driving Violations'!F2:F500,1)
whats wrong with this?
edit, the table is not sorted, thats why it didnt work.
but basically this is what I need:
=COUNT(VLOOKUP(A6,DrivingViolations!F2:F500,1))
But I cant use vlookup because the table is not sorted, what are my other options instead of vlookup?
Bookmarks