Hi!

Try this:

=INDEX(A1:A10,MATCH(MAX(AQ1:AQ10),AQ1:AQ10,0))

Note: if there are multiple instances of MAX the formula will match the
first instance.

Biff

"mailrail" wrote in message
...
I am trying to write a formula (no luck so far) that will find the highest
value in a list of numbers and then associate it with an office name in
column A. The problem I'm having is that the totals are way over in column
AQ. I then want to transfer the office name to one cell and the value to
another like OFFICE NAME: and then AMOUNT: (and paste the values into a
blank
cell next to it). Anyone?