Show a label which corresponds to a max function

[colmdoherty8]

I am making a spreadsheet which will display the top performing locations at my company in several different categories.
The way I have it laid out right now is...
Category Location Amount
Category Location Amount etc.
I have the categories written in as text, and I have the amounts there using the max function... what I don't know is how to show the location which corresponds to the amount found by the max function.

On the sheet where the Amount is being taken from the name of the location appears on the far left with all the categories coming out from it in subsequent columns. So the Location name I want would always be the furthest to the left column, in the same row as the one chosen by the max function.

I don't know how to make this work, I'm thinking maybe some variant of offset and if, but I don't know for sure.

If anyone could help it would be greatly appreciated.

[NBVC]

You would use a combination of Index and Match functions...

eg.

=Index(LabelRange,Match(MaxNum,Range,0))

where Label Range is your column of Labels to return...
MaxNum is the maximum number or cell reference to that number
Range is the range of numbers to find that max number and pull from the LabelRange.

e.g =Index($A$1:$A$100,Match(X1,$B$1:$B$100,0)) where X1 contains the Max Number to search for.

[sweep]

Hi,

Presuming Category in A1:A100, Location in B1:B100 and Amount in C1:C100

=index(B1:B100,match(max(C1:C100),C1:C100,0))