Lookup?? Issue

OK, here's what i want to do. I have a spreadsheet (condensed below)

Store Location ID Acc Amount
A 67583 $2895
B 78594 $5000
C 26974 $3968

I want to be able to have a cell that has the max value (in this case
5000)formula and gives me, in another cell, the store name.

i.e. cell a6 has =max(c1:c3)
cell a5 automatically enters Store B (or B in this case)
because 5000 is the max amount.

I have tried the lookup wizard and can type in store A and get 2895, I
want it to utilize the info in cell a6 in this example and give me the
store name.

Fester

=INDEX(Store_Location,MATCH(MAX(Acc_Amount),Acc_Amount,0))

--

Regards,

Peo Sjoblom


<[email protected]> wrote in message
news:[email protected]...
> OK, here's what i want to do. I have a spreadsheet (condensed below)
>
> Store Location ID Acc Amount
> A 67583 $2895
> B 78594 $5000
> C 26974 $3968
>
> I want to be able to have a cell that has the max value (in this case
> 5000)formula and gives me, in another cell, the store name.
>
> i.e. cell a6 has =max(c1:c3)
> cell a5 automatically enters Store B (or B in this case)
> because 5000 is the max amount.
>
> I have tried the lookup wizard and can type in store A and get 2895, I
> want it to utilize the info in cell a6 in this example and give me the
> store name.
>
> Fester
>

Thank You. Works Awesome!!!

My pleasure, thanks for the feedback

--

Regards,

Peo Sjoblom

<[email protected]> wrote in message
news:[email protected]...
> Thank You. Works Awesome!!!
>

OK, here's my next question.

I now have a list of another set of values listed below:

John 12500
Peter 16985
Rich 14986
Steve 11986
Joe 13579
Joann 12697

I want to, based on value, sort these on another sheet. Using the
formula above, I can get the MAX and MIN. How do I go about getting
the rest of the values sorted accordingly?

Fester.