Lookup?? Issue

  • Thread starter Thread starter bscarano
  • Start date Start date
B

bscarano

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
 
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.
 
Back
Top