.. what I intended ...

=INDEX($C$2:$C$5,MATCH(MAX(($A$2:$A$5="Joe")*($B$2 :$B$5)),($A$2:$A$5="Joe")*($B$2:$B$5),0))

entered with Ctrl+Shift+Enter

"Toppers" wrote:

.... no it doesn't!!!

"Toppers" wrote:

one way:

=INDEX($C$1:$C$4,MATCH(MAX(($A$1:$A$4="Joe")*($B$1 :$B$4)),$B$1:$B$4,0))

Enter with Ctrl+Shift+Enter

Substitute "Joe" with cell containing name

"Richard" wrote:

I have data like this

EMPLOYEE SALE STATE
Joe 10.00 PA
Joe 20.00 VA
Sue 5.00 TX
Sue 10.00 WA

For each employee, how do I find the state that corresponds to the largest
sale. For example, for Joe this would be VA since his largest sale of 20.00
was to VA.

--
Richard