Fleet Services

Something like

=IF(OR(MAX(INDIRECT(A5&"!"&"d2:d500"))-MAX(INDIRECT(A5&"!"&"e2:e500"))>=-500,(MAX(INDIRECT(A5&"!"&"d2:d500"))>MAX(INDIRECT(A5 &"!"&"e2:e500")))),"Yes", "No")

VBA Noob

Awsome, thats it. I was trying to get it to work, and just googled the or syntex, so i was close, but had the paranthesis wrong.

you guys have any idea for the first problem?

edit: ill try to play with the v-lookup for my first problem. im thinking that will work. but im still open to suggestions.

edit(again): I made a mistake. the formula i gave in my original post is in referrence to a third problem I did not mention. Im still working on the problems from the first post. if anyone has an answer, that would be greatly appreciated.

No Problem.

Can you confirm

Is there a tab for the driver or is it a tab for Driving Violations.

Whats in Column F and Is the driver name shown in the sheet and in what col

VBA Noob

=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?

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

Try

=COUNTIF(DrivingViolations!F:F,A3)

VBA Noob