Maximum in a Range by Customer Identifier

[sbeatty]

Hello all,

I'm a little stumped on a problem I am working with and hoping someone can help. It's essentially a simple VLOOKUP procedure but looking for the maximum match as opposed to the first available match. I've attached a sample spreadsheet because I'm sure I didn't describe it very well.

Looking for a formula if possible - not VBA or the use of a pivot table.

Thanks!
Scott