It's not clear what you want.

Do you want the highest number for Company A, and if so, from which column?

Or, do you want the date on which Company A had the highest number, and if
so, from which column?

Here's how interpreted your question: return the date on which Company A had
the highest CREDIT:

Array entered** :

=INDEX(B2:B6,MATCH(1,(A2:A6="Company A")*(C2:C6=MAX(IF(A2:A6="Company
A",C2:C6))),0))

Format as DATE

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
I have an excel spreadsheet with four columns. I have one work sheet that
needs to findest
the highest dollar amount during a period of time.

Example

Company Date Total Credits Total Debits

Company A 10/1/07 125,000 200,000
Company A 10/2/07 75,500 125,000
Company B 10/2/07 500,000 1,000
Company A 10/3/07 400,000 100,000
Company B 10/5/07 200,000 200,000


So the worksheet would first need to look for all the ones that have
company
A and then look for the highest number. So in this case it would have
happened on 10/3/2007 (15). I would think this would involve a vlookup,
but
can't figure how to write it. Could someone lend some insight. Anything
will help
Thanks