VLOOKUP - odd behavior

[dkubiak]

=VLOOKUP(MAX(CI134:CI141),CG134:CH141,2,TRUE)

Column CH contains a list of error types.
Column CI contains a count of the those error types.
Column CG equals CI (in order to use VLOOKUP).

The function at the top should give me the error type from CH that has the highest count. It does that for the error type listed in CH139. But, when any of the other error types have the MAX count, it defaults to the error type in CH141.

Any ideas?!?!

 

[Jonmo1]

Try changing the TRUE to FALSE

OR

Sort the data ASCENDING by column CI

 

[dkubiak]

Changing to false worked great. Thank you.