Display a Value from a Cell

[dadrew]

I have a sheet, along the top is the Months of the year, to the side I have a list of products. At the bottom of each month in a cell I want to display the name of the product that has sold the most for that moth, is this possible:

I can display the highest number i.e Highest item sold in January was 108, but I want it to write the product name.

Hope that makes sense!

[oeldere]

Show us the excel file, without confidentional information.

Please also add the desired (expected) result.

[Moo the Dog]

Here is an example of how to do it. See the attached sheet. It uses the formula:

Please Login or Register  to view this content.

As you will notice, two products tied for the most sold (A and E at 73). The formula will only return the first value it finds that matches - not both.

- Moo

[Ace_XL]

With your products ion Column A..try this at the bottom of column B

Please Login or Register  to view this content.

Copy across. Adjust ranges accordingly